On Sat, 27 Aug 2011 18:36:14 -0400 Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >Tarlika Elisabeth Schmitz <postgresql6@xxxxxxxxxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
