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.