Re: PL/pgSQL: SELECT INTO EXACT - Mailing list pgsql-patches

From Matt Miller
Subject Re: PL/pgSQL: SELECT INTO EXACT
Date
Msg-id 1122677238.7396.35.camel@dbamm01-linux
Whole thread Raw
In response to Re: PL/pgSQL: SELECT INTO EXACT  (Jaime Casanova <systemguards@gmail.com>)
List 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 by date:

Previous
From: Matt Miller
Date:
Subject: Re: PL/pgSQL: SELECT INTO EXACT
Next
From: Bruce Momjian
Date:
Subject: Re: INSERT ... RETURNING