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, 

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 по дате отправления:

Предыдущее
От: Philippe Girolami
Дата:
Сообщение: Re: Should a DB vacuum use up a lot of space ?
Следующее
От: Christian Ohler
Дата:
Сообщение: Re: Detecting if current transaction is modifying the database