| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "mascarm(at)mascari(dot)com" <mascarm(at)mascari(dot)com> |
| Cc: | "'The Hermit Hacker'" <scrappy(at)hub(dot)org>, Lark <litr(at)beer(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Does PostgreSQL support Dynamic SQL? |
| Date: | 2001-01-15 05:17:20 |
| Message-ID: | 21193.979535840@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mike Mascari <mascarm(at)mascari(dot)com> writes:
> Its an extension to the embedded SQL preprocessor which allows you to
> dynamically build queries at run-time, instead of compile-time.
> [...]
> you can *dynamically* build a SELECT statement, ask the database for a
> description of the result sets' attributes, allocate the variables
> dynamically to hold the results, and then perform the FETCH.
Well, this is obviously trivial if you use libpq directly. I don't
know whether ecpg emulates the spec's idea of the right API for it,
however.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anand Raman | 2001-01-15 05:42:40 | Re: Newbie question |
| Previous Message | Chris Ian Capon Fiel | 2001-01-15 04:28:55 | Re: VB and PostgreSQL |