Index: openacs-4/contrib/packages/classified-ads/tcl/categories-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/classified-ads/tcl/categories-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/classified-ads/tcl/categories-procs-postgresql.xql	16 Jul 2003 04:52:32 -0000	1.1
+++ openacs-4/contrib/packages/classified-ads/tcl/categories-procs-postgresql.xql	29 Jul 2003 09:10:42 -0000	1.2
@@ -97,5 +97,27 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="classified-ads::categories::get_custom_fields.get_fields">
+        <querytext>
+            
+	    SELECT 
+	           attribute_name
+	      FROM 
+	           acs_attributes att,
+		   ca_attribute_widget_values cawv,
+		   (
+		            select 
+                		   subtree.keyword_id
+		              from cr_keywords parent, cr_keywords subtree
+		             where parent.keyword_id = :keyword_id 
+			       and parent.tree_sortkey between subtree.tree_sortkey and tree_right(subtree.tree_sortkey)
+		   ) keywords
+	    WHERE
+	          att.attribute_id = cawv.attribute_id
+	      AND
+	          cawv.keyword_id = keywords.keyword_id
+	           
+        </querytext>
+    </fullquery>
 
 </queryset>