Home > mailing lists

Re: if not exists (SELECT 1... UNION SELECT 1...) - Mailing list pgsql-general

From	Ralf Schuchardt
Subject	Re: if not exists (SELECT 1... UNION SELECT 1...)
Date	February 16, 2022 18:44:36
Msg-id	9F4935D6-F0D0-42BE-B26B-77F72BC74D4B@gmx.de Whole thread Raw
In response to	Re: if not exists (SELECT 1... UNION SELECT 1...) (Alexander Farber <alexander.farber@gmail.com>)
Responses	Re: if not exists (SELECT 1... UNION SELECT 1...) (Alexander Farber <alexander.farber@gmail.com>)
List	pgsql-general

On 16 Feb 2022, at 14:36, Alexander Farber wrote:

Ah, I have to do
RETURN '___WRONG___';

Not necessarily.

and not
out_text := '___WRONG___'
RETURN;

You must rather end the assignment with a semicolon:

out_text := '___WRONG___';
RETURN;

Otherwise what really happens is:

out_text := '___WRONG___' RETURN;

where „return“ is a simple column name as in this select statement:

select '___WRONG___' return;

Yours,
Ralf

From: Alexander Farber
Date: 16 February 2022, 16:36:23
Subject: Re: if not exists (SELECT 1... UNION SELECT 1...)

From: Alexander Farber
Date: 16 February 2022, 19:23:29
Subject: Re: if not exists (SELECT 1... UNION SELECT 1...)