| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Execute Immediate |
| Date: | 2009-07-12 15:21:27 |
| Message-ID: | 162867790907120821h1aab9ee4ja9088864a4cbd0c3@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello
plpgsql has execute statement, that has similar behave like execute
immediate in others systems.
note - postgresql doesn't support global temp tables yet.
regards
Pavel Stehule
2009/7/12 Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net>:
> In many SQL dialets there is the availability of Execute immediate which
> allows you to build global temp tables or views at run time and even stored
> procedures at runtime and then execute them inline. Is there a way to do
> this in PostGres 8.4
>
>
>
> Best Regards
>
>
>
> ________________________________
> Michael Gould, Managing Partner
> Intermodal Software Solutions, LLC
> 904.226.0978
> 904.592.5250 fax
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2009-07-12 15:53:50 | Re: [BUGS] BUG #4916: wish: more statistical functions (median, percentiles etc) |
| Previous Message | dkeeney | 2009-07-12 15:20:39 | Postgresql databases as a web service |