Catch multiple records when doing Select Into

Поиск
Список
Период
Сортировка
От SunWuKung
Тема Catch multiple records when doing Select Into
Дата
Msg-id 1162286132.537469.8770@m7g2000cwm.googlegroups.com
обсуждение исходный текст
Ответы Re: Catch multiple records when doing Select Into  ("Ketema" <ketema@gmail.com>)
Список pgsql-general
I have a SELECT INTO varname columname FROM ... statement and I would
like to raise an exception when that returns more than one record.
GET DIAGNOSTICS rowcount = ROW_COUNT seems to return always one for
this. Currently I find no other way to do that than to run this
statement twice - first to see how many records it returns, which seems
very inefficient.

I can see that this will be handled for 8.2, but for 8.1 what is the
best practice to do this?

Thanks.
SWK


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

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Counting records in a PL/pgsql cursor
Следующее
От: "Ketema"
Дата:
Сообщение: Select permissions on System tables