Re: PostgresQL equivalent of NOCOUNT - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: PostgresQL equivalent of NOCOUNT
Date
Msg-id 20010815005006.A7173@svana.org
Whole thread Raw
In response to PostgresQL equivalent of NOCOUNT  (Jochem van Dieten <jochemd@oli.tudelft.nl>)
List 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 by date:

Previous
From: Craig Longman
Date:
Subject: cmd-line interface
Next
From: Vince Vielhaber
Date:
Subject: Re: Is the bug system active?