Re: PostgresQL equivalent of NOCOUNT

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: PostgresQL equivalent of NOCOUNT
Дата
Msg-id 20010815005006.A7173@svana.org
обсуждение исходный текст
Ответ на PostgresQL equivalent of NOCOUNT  (Jochem van Dieten <jochemd@oli.tudelft.nl>)
Список pgsql-general
On Tue, Aug 14, 2001 at 03:38:08PM +0200, Jochem van Dieten wrote:
> Does PostgresQL have some way to make update, insert and delete queries
> not return the number of affected rows? I know that in MS SQL one would
> use NOCOUNT for that.

Just ignore the result. Postgres has to find all the rows anyway, so
avoiding counting them is hardly going to save any time.

Am I missing something?

--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> It would be nice if someone came up with a certification system that
> actually separated those who can barely regurgitate what they crammed over
> the last few weeks from those who command secret ninja networking powers.

В списке pgsql-general по дате отправления:

Предыдущее
От: Craig Longman
Дата:
Сообщение: cmd-line interface
Следующее
От: Vince Vielhaber
Дата:
Сообщение: Re: Is the bug system active?