Re: select into

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: select into
Дата
Msg-id
28318.1164343519@sss.pgh.pa.us
Ответ на
Re: select into (Mulham freshcode)
Список
Дерево обсуждения
select into Mulham freshcode <mulhamcode@yahoo.com>
Re: select into Tom Lane <tgl@sss.pgh.pa.us>
Re: select into "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: select into Mulham freshcode <mulhamcode@yahoo.com>
Re: select into Adrian Klaver <aklaver@comcast.net>
Re: select into Mulham freshcode <mulhamcode@yahoo.com>
Re: select into Tom Lane <tgl@sss.pgh.pa.us>
Re: select into Adrian Klaver <aklaver@comcast.net>
Re: select into Andreas Kretschmer <akretschmer@spamfence.net>
Re: select into Adrian Klaver <aklaver@comcast.net>
Re: select into Tom Lane <tgl@sss.pgh.pa.us>
Re: select into Mulham freshcode <mulhamcode@yahoo.com>
Re: select into Adrian Klaver <aklaver@comcast.net>
Re: select into Mulham freshcode <mulhamcode@yahoo.com>
Re: select into Adrian Klaver <aklaver@comcast.net>
Re: select into Adrian Klaver <aklaver@comcast.net>
Re: select into Mulham freshcode <mulhamcode@yahoo.com>
Re: select into Adrian Klaver <aklaver@comcast.net>
Re: select into Richard Broersma Jr <rabroersma@yahoo.com>
Re: select into Andreas Kretschmer <akretschmer@spamfence.net>
Re: select into Richard Broersma Jr <rabroersma@yahoo.com>
Mulham freshcode  writes:
> execute sql_str1 into svc_data_rec ;

> svc_data_rec is a RECORD, which is supposed to be dynamic.

This should work --- in PG 8.1 or later.  In older versions you'd have
to fool around with a FOR ... IN EXECUTE ... loop.
		regards, tom lane

В списке pgsql-sql по дате отправления
От: Mulham freshcode
Дата:
Сообщение: Re: select into
От: Mulham freshcode
Дата:
Сообщение: Re: select into
FAQ