Home > mailing lists

Re: Problem with dynamic query - Mailing list pgsql-sql

From	Tomasz Myrta
Subject	Re: Problem with dynamic query
Date	December 5, 2003 12:03:32
Msg-id	3FD081CB.2050901@klaster.net Whole thread Raw
In response to	Problem with dynamic query ("Kumar" <sgnerd@yahoo.com.sg>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: "Kumar"
Date: 05 December 2003, 11:46:56
Subject: Problem with dynamic query

From: Olivier Hubaut
Date: 05 December 2003, 14:44:50
Subject: Is it possible to set a NOT NULL constraint deferrable?

Re: Problem with dynamic query - Mailing list pgsql-sql

Previous

Next