Index: openacs-4/packages/clickthrough/tcl/clickthrough-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/clickthrough/tcl/clickthrough-procs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/clickthrough/tcl/clickthrough-procs-postgresql.xql	3 May 2001 21:35:57 -0000	1.2
+++ openacs-4/packages/clickthrough/tcl/clickthrough-procs-postgresql.xql	4 May 2001 19:29:55 -0000	1.3
@@ -3,16 +3,28 @@
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
+<fullquery name="clickthrough_href.clickthrough_url_sql">
+      <querytext>
+      select site_node__url(sn2.node_id)
+          from site_nodes sn1, site_nodes sn2, apm_packages p
+         where sn1.object_id = :package_id
+           and sn2.parent_id = sn1.node_id
+           and sn2.object_id = p.package_id
+           and p.package_key = 'clickthrough'
+      </querytext>
+</fullquery>
+
+
 <fullquery name="clickthrough_cache_sweeper.update_clickthrough_log_sql">      
       <querytext>
-      
-			update clickthrough_log 
+
+			update clickthrough_log
 			   set click_count = click_count + :cached_click_count
-			 where local_url = :cached_local_url 
+			 where local_url = :cached_local_url
 			   and foreign_url = :cached_foreign_url
 			   and package_id = :cached_package_id
 			   and trunc(entry_date) = trunc(current_time)
-		    
+
       </querytext>
 </fullquery>