Re: strange construct with RETURN within plpgsql

From: mariusz <marius(at)mtvk(dot)pl>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: strange construct with RETURN within plpgsql
Date: 2018-02-16 13:20:03
Message-ID: 1518787203.10667.105.camel@mtvk.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thiemo Kellner, NHC Barhufpflege 2018-02-16 13:47:22 Re: Dynamic PL/pgSQL select query: value association propblem
Previous Message David G. Johnston 2018-02-16 13:17:28 Re: strange construct with RETURN within plpgsql