Re: Can't use WITH in a PERFORM query in PL/pgSQL? - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Date
Msg-id CAFj8pRC1be1ckLOhiJpSQBpWs1ijLh=poRrCpFRbrsEtmKTNqA@mail.gmail.com
Whole thread Raw
In response to Re: Can't use WITH in a PERFORM query in PL/pgSQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Can't use WITH in a PERFORM query in PL/pgSQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
2011/10/20 Tom Lane <tgl@sss.pgh.pa.us>:
> Valentine Gogichashvili <valgog@gmail.com> writes:
>> And, ernestly, if it were useless to have SELECT without INTO in plpgsql,
>> there also would be no PERFORM command in plpgsql...
>
> Precisely. =C2=A0Pavel's claim is nonsense. =C2=A0The only real question =
is how
> useful is it to call it PERFORM instead of SELECT.

I didn't design a PERFORM statement. There is two views - somebody
from sybase's family know so SELECT without into is forwarded to
client. This functionality is missing on Oracle's family. Is true so
PERFORM statement is strange,  but maybe it's open door for sybase's
functionality that was not implemented ever.

Regards

Pavel Stehule


>
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0regards, tom lane
>

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Next
From: Tom Lane
Date:
Subject: Re: BUG #6263: \l causes core dump with large database