Hello 2011/3/25 Luca Santaniello <luca.santaniello.81@xxxxxxxxx>: > 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 EXECUTE 'SELECT .. FROM ' || quote_ident(tableName) || ' ....' LOOP ... you can use OPEN FOR EXECUTE too, but FOR statement is preferable Regards Pavel Stehule http://www.postgresql.org/docs/9.0/interactive/plpgsql-cursors.html#PLPGSQL-CURSOR-OPENING > 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.81@xxxxxxxxx > skype: luca.santaniello > msn: luketto81@xxxxxxxxxxx > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
