Re: Dynamic SQL with pgsql, how to?

[Andre Lopes <lopes80andre@xxxxxxxxx>]

Thanks for the reply,

It is working now.

Best Regards.

On Tue, May 4, 2010 at 7:44 AM, Maximilian Tyrtania <maximilian.tyrtania@xxxxxxxxxxxxxxxx> wrote:

Am 03.05.2010 um 23:50 schrieb Andre Lopes:

> Thanks for the reply's,
>
> I need to do a Dynamic SELECT INTO. There is a way of doing it?

Yes. Plpgsql supports this:

EXECUTE command-string [ INTO [STRICT] target ] [ USING _expression_ [, ... ] ];

See http://developer.postgresql.org/pgdocs/postgres/plpgsql-statements.html

Max

Maximilian Tyrtania Software-Entwicklung
Dessauer Str. 6-7
10969 Berlin
Tel.:    ++49/30/48827-952
Mobil: 0152/292 707 36
email: maximilian.tyrtania@xxxxxxxxxxxxxxxx