Hi all, I need use dinamic string for my cursor... My code is:
query varchar := 'field1, field2 from ''' || tableName ||''' ........; //has dinamic params
then I create cursor... myCursor CURSOR FOR SELECT query; I compile my function but when i run it I obtain error... ERROR: invalid input syntax for integer: ...... CONTEXT: PL/pgSQL function "my_function" line 72 at FETCH If I use static string, I don't have problems!!! Can I solve it? Thanks in advance -- Luca Santaniello email: [email protected] skype: luca.santaniello msn: [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
