Re: strange construct with RETURN within plpgsql - Mailing list pgsql-general

From mariusz
Subject Re: strange construct with RETURN within plpgsql
Date
Msg-id 1518787203.10667.105.camel@mtvk.pl
Whole thread Raw
In response to Re: strange construct with RETURN within plpgsql  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: strange construct with RETURN within plpgsql
List pgsql-general
On Fri, 2018-02-16 at 13:51 +0100, Pavel Stehule wrote:


> It is not a bug, it is feature. Sometimes not nice. RETURN is keyword
> in procedural part, but it is nothing in sql part.
> 
thanks, i haven't thought about such an obvious thing, i feel really
ashamed.
of course it makes sense now. i guess what mislead me was that statement
var := val and forgetting that it's like select into under the hood, and
even when i put strict select into in examples i didn't spot this (it
must have been a very long week and i definitely need some rest)
thanks again

regards,
mj





pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: strange construct with RETURN within plpgsql
Next
From: "Thiemo Kellner, NHC Barhufpflege"
Date:
Subject: Re: Dynamic PL/pgSQL select query: value association propblem