Quick Links

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

From:	Merlin Moncure <mmoncure(at)gmail(dot)com>
To:	Pavel Stehule <pavel(dot)stehule(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 13:32:38
Message-ID:	CAHyXU0wnLGOSYqdQy-jwxXQUPfJNcwPLdRX9QYdZ-XiUQsDyig@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-bugs

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();

merlin

In response to

Re: Can't use WITH in a PERFORM query in PL/pgSQL? at 2011-10-20 07:28:36 from Pavel Stehule

Responses

Re: Can't use WITH in a PERFORM query in PL/pgSQL? at 2011-10-20 16:19:31 from Valentine Gogichashvili
Re: Can't use WITH in a PERFORM query in PL/pgSQL? at 2011-10-20 17:04:28 from Pavel Stehule

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	Valentine Gogichashvili	2011-10-20 16:19:31	Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Previous Message	Maruthi Kiran	2011-10-20 12:01:52	BUG #6262: while installing postgis in make install leavingdirectory