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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: if not exists (SELECT 1... UNION SELECT 1...)
Date: 2022-02-16 17:06:38
Message-ID: 45c68bd56c1b0cdcd4b7e67739a45243196bd2af.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2022-02-16 at 14:36 +0100, Alexander Farber wrote:
> Ah, I have to do
>
>     RETURN '___WRONG___';
>
> and not
>
>         out_text := '___WRONG___'
>         RETURN;

Yes. As I said, a trivial error.

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Carsten Klein 2022-02-16 18:38:01 Re: Strange results when casting string to double
Previous Message Adrian Klaver 2022-02-16 16:57:44 Re: How to disable read-only mode on a table? (superUser)