Re: PL/pgSQL: SELECT INTO only if result count = 1

Поиск
Список
Период
Сортировка
От Tarlika Elisabeth Schmitz
Тема Re: PL/pgSQL: SELECT INTO only if result count = 1
Дата
Msg-id 20110828002028.2f040e14@dick.coachhouse
обсуждение исходный текст
Ответ на Re: PL/pgSQL: SELECT INTO only if result count = 1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Sat, 27 Aug 2011 18:36:14 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:

>Tarlika Elisabeth Schmitz <postgresql6@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.

What a life saver late on a Saturday night! That does the trick.

--

Best Regards,
Tarlika Elisabeth Schmitz

В списке pgsql-general по дате отправления:

Предыдущее
От: pasman pasmański
Дата:
Сообщение: Re: Problem importing a csv file
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Call for translations