Re: [GENERAL] Row fields by position in a cursor

2005-03-01 Thread Tom Lane
"Mike Preston" <[EMAIL PROTECTED]> 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 succes

[GENERAL] Row fields by position in a cursor

2005-03-01 Thread 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 syn