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: luca.santaniello...@gmail.com skype: luca.santaniello msn: lukett...@hotmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
