pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem with dynamic query
2+ messages / 2 participants
[nested] [flat]
* Problem with dynamic query
@ 2003-12-05 12:43 Kumar <sgnerd@yahoo.com.sg>
0 siblings, 1 reply; 2+ messages in thread
From: Kumar @ 2003-12-05 12:43 UTC (permalink / raw)
To: pgsql-sql
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.project_role_id IN\'||\'(\'|| p_res_ids||\')
AND usr.usr_id = project_members.usr_id
ORDER BY usr.full_name)foo\';
RETURN ref;
While I try to assign the value into a local variable v_names , it is not working
EXECUTE
\'SELECT comma(full_name) INTO '||v_names||' FROM (SELECT usr.full_name
FROM project_members,users usr
WHERE project_members.project_role_id IN\'||\'(\'|| p_res_ids||\')
AND usr.usr_id = project_members.usr_id
ORDER BY usr.full_name)foo\';
RETURN v_names;
Why is it so. Cant I use 'INTO [variable_name]' inside a dynamic query. Please shed some light.
Regards
Kumar
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Problem with dynamic query
@ 2003-12-05 13:02 Tomasz Myrta <jasiek@klaster.net>
parent: Kumar <sgnerd@yahoo.com.sg>
0 siblings, 0 replies; 2+ messages in thread
From: Tomasz Myrta @ 2003-12-05 13:02 UTC (permalink / raw)
To: Kumar <sgnerd@yahoo.com.sg>; +Cc: pgsql-sql
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 use the FOR-IN-EXECUTE form"
Regards,
Tomasz Myrta
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-12-05 13:02 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-05 12:43 Problem with dynamic query Kumar <sgnerd@yahoo.com.sg>
2003-12-05 13:02 ` Tomasz Myrta <jasiek@klaster.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox