On Sat, 27 Aug 2011 18:36:14 -0400 Tom Lane <[email protected]> wrote:
>Tarlika Elisabeth Schmitz <[email protected]> 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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
