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. I suspect though that it'd be more efficient to use a FOR loop and just note for yourself how many rows you get. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
