Re: [GENERAL] PL/pgSQL: SELECT INTO variables - no result

2011-11-10 Thread Tarlika Elisabeth Schmitz
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

[GENERAL] PL/pgSQL: SELECT INTO variables - no result

2011-11-10 Thread Tarlika Elisabeth Schmitz
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,