Tarlika Elisabeth Schmitz <postgres...@numerixtechnology.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. 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
