I am building a generic crosstab function in plpgsql, where I can pass in a SQL statement and return back the data pivoted with the values of one column serving as headers of the return columns. If I use a RECORD variable to scroll through the data, is there a way for me to tell the number of fields returned by the SQL statement parameter?
No. You'll want to use pltcl or plperl or some similar more-dynamic language.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
