| From: | Andre Lopes <lopes80andre(at)gmail(dot)com> |
|---|---|
| To: | Maximilian Tyrtania <maximilian(dot)tyrtania(at)byte-employer(dot)de> |
| Cc: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Dynamic SQL with pgsql, how to? |
| Date: | 2010-05-04 08:16:34 |
| Message-ID: | k2q18f98e681005040116zd215905dr7266926c5bbf5091@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks for the reply,
It is working now.
Best Regards.
On Tue, May 4, 2010 at 7:44 AM, Maximilian Tyrtania <
maximilian(dot)tyrtania(at)byte-employer(dot)de> 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(dot)tyrtania(at)byte-employer(dot)de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grzegorz Jaśkiewicz | 2010-05-04 08:19:05 | Re: information_schema.parameters |
| Previous Message | Leif Biberg Kristensen | 2010-05-04 08:01:38 | Re: GeSHi module for Postgresql? |