Quick Links

Fetch zero result rows when executing a query?

From:	Shay Rojansky <roji(at)roji(dot)org>
To:	pgsql-hackers(at)postgresql(dot)org
Subject:	Fetch zero result rows when executing a query?
Date:	2015-02-03 11:26:33
Message-ID:	CADT4RqCMeE8Pb+KqBt7qWk2nTWYiwrY07Lzt7oshnN_93PL7TQ@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

Sorry if this has been asked before, couldn't find any mention...

I'm working on the Npgsql, the .NET driver for PostgreSQL, and am trying to
find a way to execute a query but without fetching any rows. The Execute
message has a maximum result-row count, but zero is documented to mean
"fetch all rows".

The use case would be sending a query which might modify or might not (e.g.
UPDATE), but we know that the user is uninterested in any result row.

My current workaround is to specify maxrows=1, was wondering if I missed a
better alternative.

Thanks,

Shay

Responses

Re: Fetch zero result rows when executing a query? at 2015-02-03 11:31:12 from Andres Freund
Re: Fetch zero result rows when executing a query? at 2015-02-04 05:55:04 from Jim Nasby
Re: Fetch zero result rows when executing a query? at 2015-02-04 11:13:52 from Stephen R. van den Berg
Re: Fetch zero result rows when executing a query? at 2015-02-04 16:16:09 from David G Johnston

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Andres Freund	2015-02-03 11:31:12	Re: Fetch zero result rows when executing a query?
Previous Message	Sawada Masahiko	2015-02-03 11:09:50	Re: Proposal : REINDEX xxx VERBOSE