Re: PL/pgSQL: SELECT INTO only if result count = 1

On Sat, 27 Aug 2011 18:36:14 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

>Tarlika Elisabeth Schmitz <postgresql6(at)numerixtechnology(dot)de> writes:
>> SELECT INTO
>> country_id, region_id, town_id
>> country_fk, region_fk, id
>> FROM town
>> WHERE ...;
>
>> GET DIAGNOSTICS cnt = ROW_COUNT;
>> RAISE DEBUG 'COUNT %', cnt;
>
>> always returns 1
>
>Yeah. By default, SELECT INTO just fetches one row and stops;
>it doesn't look to see if there are more.
>
>You could possibly use SELECT INTO STRICT and catch the error if
>there's more than one row.

What a life saver late on a Saturday night! That does the trick.

--

Best Regards,
Tarlika Elisabeth Schmitz