Обсуждение: Row fields by position in a cursor

Поиск
Список
Период
Сортировка

Row fields by position in a cursor

От
"Mike Preston"
Дата:
I am passing a SQL statement to a function as a parameter and then executing it via a call like
 
OPEN curs1 FOR EXECUTE sql_str;
 
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?  Doesn't seem to be much documentation on dereferencing info returned by a cursor.  I can fetch into either a record variable or a row variable, whichever works.
 
TIA,
Mike

Re: Row fields by position in a cursor

От
Tom Lane
Дата:
"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