Re: PL/pgSQL: SELECT INTO EXACT

Поиск
Список
Период
Сортировка
От Matt Miller
Тема Re: PL/pgSQL: SELECT INTO EXACT
Дата
Msg-id 1122677238.7396.35.camel@dbamm01-linux
обсуждение исходный текст
Ответ на Re: PL/pgSQL: SELECT INTO EXACT  (Jaime Casanova <systemguards@gmail.com>)
Список pgsql-patches
> > The motivation is to come closer
> > to Oracle's SELECT INTO behavior: when SELECTing INTO scalar targets,
> > raise an exception and leave the targets untouched if the query does not
> > return exactly one row.

> why that is not the default behavior of the SELECT INTO?
> ...
> i mean, when you do that code you are expecting just one row from your
> query

I agree.  I suppose I was fearful of breaking existing stuff, so I added
a new keyword.

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

Предыдущее
От: Matt Miller
Дата:
Сообщение: Re: PL/pgSQL: SELECT INTO EXACT
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: INSERT ... RETURNING