Re: Referencing Cursor/Row/Record Fields in PL/PgSQL
От
Lee Hughes
Тема
Re: Referencing Cursor/Row/Record Fields in PL/PgSQL
Дата
Msg-id
2d739b560902101616h25793ac7gc1fdf7390acb3128@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Referencing Cursor/Row/Record Fields in PL/PgSQL Lee Hughes <lee@hughesys.com>
Re: Referencing Cursor/Row/Record Fields in PL/PgSQL Tom Lane <tgl@sss.pgh.pa.us>
Re: Referencing Cursor/Row/Record Fields in PL/PgSQL Lee Hughes <lee@hughesys.com>
Re: Referencing Cursor/Row/Record Fields in PL/PgSQL Pavel Stehule <pavel.stehule@gmail.com>
Re: Referencing Cursor/Row/Record Fields in PL/PgSQL Lee Hughes <lee@hughesys.com>
Re: Referencing Cursor/Row/Record Fields in PL/PgSQL Pavel Stehule <pavel.stehule@gmail.com>
I thought that's what EXECUTE was for in plpgsql -- isn't there a way to extract the value of a field in a row/record variable by building a SELECT string and passing it to EXECUTE?
On Tue, Feb 10, 2009 at 1:22 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Lee Hughes <lee@hughesys.com> writes:There isn't any --- plpgsql doesn't deal in accesses to unknown fields
> 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.
(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 по дате отправления
