Re: Problem with dynamic query

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Kumar <sgnerd(at)yahoo(dot)com(dot)sg>
Cc: psql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Problem with dynamic query
Date: 2003-12-05 13:02:03
Message-ID: 3FD081CB.2050901@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Olivier Hubaut 2003-12-05 15:47:07 Is it possible to set a NOT NULL constraint deferrable?
Previous Message Kumar 2003-12-05 12:43:50 Problem with dynamic query