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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Дата
Msg-id CAFj8pRC1be1ckLOhiJpSQBpWs1ijLh=poRrCpFRbrsEtmKTNqA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Can't use WITH in a PERFORM query in PL/pgSQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Can't use WITH in a PERFORM query in PL/pgSQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6263: \l causes core dump with large database