bug in PLPGSQL
| От | Kovacs Zoltan |
|---|---|
| Тема | bug in PLPGSQL |
| Дата | |
| Msg-id | Pine.LNX.4.21.0105141032120.941-100000@pc10.radnoti-szeged.sulinet.hu обсуждение исходный текст |
| Ответ на | Re: \c connects as another user instead I want in psql (Jan Wieck <JanWieck@Yahoo.com>) |
| Ответы |
Re: bug in PLPGSQL
|
| Список | pgsql-hackers |
In 7.1.1 the following statement doesn't work (backend closes
immediately):
SELECT INTO var1, var2 col1, col2 FROM table WHERE conditions;
In 7.1 (final) this problem doesn't occur.
Workaround:
var1 := col1 FROM table WHERE conditions;
var2 := col2 FROM table WHERE conditions;
(Of course I'd better not rewrite my 200K code of PLGSQL... :-)
TIA, Zoltan
-- Kov\'acs, Zolt\'an kovacsz@pc10.radnoti-szeged.sulinet.hu
http://www.math.u-szeged.hu/~kovzol ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz
В списке pgsql-hackers по дате отправления: