Re: PL/pgSQL: SELECT INTO EXACT

Matt Miller <mattm@epx.com>

From: Matt Miller <mattm@epx.com>
To: Jaime Casanova <systemguards@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-patches <pgsql-patches@postgresql.org>
Date: 2005-07-29T22:47:18Z
Lists: pgsql-hackers
> > 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.