Re: Can't use WITH in a PERFORM query in PL/pgSQL?

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Valentine Gogichashvili <valgog(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Date: 2011-10-20 17:04:28
Message-ID: CAFj8pRBdwyRBA1jKfy5Wt6n5dfAOdxo_2r7y5zn3-_Pa7ZYHCA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

2011/10/20 Merlin Moncure <mmoncure(at)gmail(dot)com>:
> On Thu, Oct 20, 2011 at 2:28 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>>>
>>> it would be really a good idea to allow SELECT without INTO in plpgsql.
>>
>> SELECT without INTO is useless in plpgsql - because you have to drop result.
>
> not if you're calling a function:
> select func();

it is correct just for void function.

Pavel

>
> merlin
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-10-20 17:09:58 Re: BUG #6262: while installing postgis in make install leavingdirectory
Previous Message Robert Messer 2011-10-20 16:22:46 BUG #6263: \l causes core dump with large database