Search Postgresql Archives

Row fields by position in a cursor

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

 



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

[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