Field count in a RECORD variable - plpgsql
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?
thanks in advance for any suggestions,
Mike
Mike Preston wrote:
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