Search Postgresql Archives

Re: Determining the names of columns in a dynamic query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux