On 2009-04-24, Johan Nel <johan555.nel555@xxxxxxxxxxxxxxx> wrote: > Hi, > > Sorry for cross posting, but seems nobody read the pgsql.sql NG. Have > not received any response there so lets see if this create some reaction. > > Is it possible in pgsql to have something to manipulate columns where > the column names will only be resolved during execution of the select > statement: no. > FOR rec IN (SELECT * FROM table) > LOOP > -- This is what I would like to do > FOR col IN (rec.column_names) > LOOP > For the above, it does not need to be exactly the same, but are there a > group of functions available to at least return in a dynamic query the > number of columns, name of a column given the ordinal number of the > column, etc? not in plpgsql, you have to use a different language like plpython, plperl, or C. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
