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 EXECUTE 'SELECT .. FROM ' || quote_ident(ta

Re: [GENERAL] cursor with dinamic string

2011-03-25 Thread Pavel Stehule
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 EXECUTE 'SELECT .. FROM ' || quote_ident(tableName) ||