Re: Does PostgreSQL support Dynamic SQL?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Does PostgreSQL support Dynamic SQL?
Дата
Msg-id 21193.979535840@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE: Does PostgreSQL support Dynamic SQL?  (Mike Mascari <mascarm@mascari.com>)
Список pgsql-general
Mike Mascari <mascarm@mascari.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Mike Mascari
Дата:
Сообщение: RE: Does PostgreSQL support Dynamic SQL?
Следующее
От: Anand Raman
Дата:
Сообщение: Re: Newbie question