Re: Referencing Cursor/Row/Record Fields in PL/PgSQL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Referencing Cursor/Row/Record Fields in PL/PgSQL
Дата
Msg-id 24610.1234300942@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Referencing Cursor/Row/Record Fields in PL/PgSQL  (Lee Hughes <lee@hughesys.com>)
Ответы Re: Referencing Cursor/Row/Record Fields in PL/PgSQL  (Lee Hughes <lee@hughesys.com>)
Список pgsql-general
Lee Hughes <lee@hughesys.com> writes:
> Trying to figure out how to reference a field in a cursor result, or in a
> row/record variable that I've FETCHed the cursor into, where the target
> field name is in a variable or parameter. I think I'm just missing the
> dereferencing syntax.

There isn't any --- plpgsql doesn't deal in accesses to unknown fields
(mainly because it can't know their type, and it's a strongly typed
language).  Consider plperl or plpython or pl-anything-but-pgsql.

            regards, tom lane

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

Предыдущее
От: Lee Hughes
Дата:
Сообщение: Referencing Cursor/Row/Record Fields in PL/PgSQL
Следующее
От: Sam Mason
Дата:
Сообщение: Re: createdb.exe and psql.exe without Promting Password