[GENERAL] cursor with dinamic string

2011-03-25 Thread Luca Santaniello
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.sa

Re: [GENERAL] cursor with dinamic string

2011-03-25 Thread Luca Santaniello
Thank you very much Hello 2011/3/25 Luca Santaniello: Hi all, I need use dinamic string for my cursor... My code is: query varchar := 'field1, field2 from ''' || tableName ||''' ; //has dinamic params use a FOR EXECUTE statement FOR r IN EXECU