Any reasons for 'DO' statement not returning result?
От | Xtra Coder |
---|---|
Тема | Any reasons for 'DO' statement not returning result? |
Дата | |
Msg-id | CAL2enjJinzk_UZbTU3bRNBYuox9dn+LbzD0sBeu4v7vjrSeaag@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Any reasons for 'DO' statement not returning result?
Re: Any reasons for 'DO' statement not returning result? |
Список | pgsql-general |
Hi,
References:
I'm just curious about the reasons of the design of 'DO' statement so that it is not able to return result of the SELECT in its body.
References:
With some former experience with MsSQL server, where 'complex' script is executed easily and straightforward without any 'wrapping', like this dummy-one ...
DECLARE @a int;
DECLARE @b int;
...
select @a + @b as "a+b"
... every time I need to execute some one-time-through-away complex code in PostgreSQL which returns rowset I'm disappointed - this has to be wrapped into normal 'temp' function which I have to delete all the time in current session, thus making an anonymous 'DO' statement use-less in 95% of my use-cases.
So ... may someone know good reasons for such inconvenient design of 'DO' statement?
Thanks.
В списке pgsql-general по дате отправления: