Re: Row fields by position in a cursor - Mailing list pgsql-general

From Tom Lane
Subject Re: Row fields by position in a cursor
Date
Msg-id 23212.1109712434@sss.pgh.pa.us
Whole thread Raw
In response to Row fields by position in a cursor  ("Mike Preston" <MPreston@mosscodilis.com>)
List pgsql-general
"Mike Preston" <MPreston@mosscodilis.com> writes:
> Since I won't know in advance the fieldnames being passed by the SQL
> string, I'd like to dereference the column fields by position.  Can
> anybody tell me the syntax for doing this?

There isn't one, at least not in plpgsql.  You might have some success
in one of the other PL languages --- certainly pltcl or 8.0 plperl can
do this.

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Romagnoli
Date:
Subject: Novice Question
Next
From: Michael Romagnoli
Date:
Subject: Re: Novice Question