Re: if not exists (SELECT 1... UNION SELECT 1...)

[Ralf Schuchardt]

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