Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group