PL/pgSQL: SELECT INTO variables - no result

From: Tarlika Elisabeth Schmitz <postgresql6(at)numerixtechnology(dot)de>
To: pgsql-general(at)postgresql(dot)org>
Subject: PL/pgSQL: SELECT INTO variables - no result
Date: 2011-11-10 22:17:40
Message-ID: 20111110221740.094631b0@dick.coachhouse
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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, id
FROM vregion
WHERE (country_id IS NULL OR country_fk = country_id) AND name ILIKE
place;

If the first search found a country, and the second search fails to
find the region, the second search will set my variables to NULL. So, a
previously populated country_id will now be NULL.

Is there any way I can avoid this or do I have to use different sets of
variables?

--

Best Regards,
Tarlika Elisabeth Schmitz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J.V. 2011-11-10 22:18:47 Re: PostgreSQL uninstall fails
Previous Message Ondrej Ivanič 2011-11-10 21:50:38 Re: Learning to rephrase equivalent queries?