Re: [SQL] Problem with dynamic query

2003-12-05 Thread Tomasz Myrta
Dnia 2003-12-05 13:43, Użytkownik Kumar napisał: Why is it so. Cant I use 'INTO [variable_name]' inside a dynamic query. Please shed some light. Well, you didn't read the manual, did you? 9.5.4. Executing dynamic queries "the only way to extract a result from a dynamically-created SELECT is to

[SQL] Problem with dynamic query

2003-12-05 Thread Kumar
Dear Friends, I am using postgres 7.3.4 running on RH Linux 7.2. While writing dynamic SQL stmts, i have the following problem. Using cursor works fine.   OPEN ref FOR  EXECUTE \'SELECT  comma(full_name) FROM (SELECT usr.full_name FROM  project_members,users usr   WHERE  project_members.pro