pgsql-general@postgresql.org>
>Subject: [GENERAL] PL/pgSQL: SELECT INTO variables - no result
>
>I go through a series of SELECT INTO in a trigger function.
>
>SELECT INTO country_id id
>FROM vcountry WHERE [...];
>
>I might or o might not find a result.
>
>Next, I
I go through a series of SELECT INTO in a trigger function.
SELECT INTO country_id id
FROM vcountry WHERE [...];
I might or o might not find a result.
Next, I try to find a region within this country, if found previously,
and if not anywhere.
SELECT INTO
country_id, region_id
country_fk,