Postgres Pro
Downloads
Home   >   mailing lists

Fetch zero result rows when executing a query? - Mailing list pgsql-hackers

From Shay Rojansky
Subject Fetch zero result rows when executing a query?
Date
Msg-id CADT4RqCMeE8Pb+KqBt7qWk2nTWYiwrY07Lzt7oshnN_93PL7TQ@mail.gmail.com
Whole thread Raw
Responses Re: Fetch zero result rows when executing a query?  (Andres Freund <andres@2ndquadrant.com>)
Re: Fetch zero result rows when executing a query?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Re: Fetch zero result rows when executing a query?  ("Stephen R. van den Berg" <srb@cuci.nl>)
Re: Fetch zero result rows when executing a query?  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Sawada Masahiko
Date:
Subject: Re: Proposal : REINDEX xxx VERBOSE
Next
From: Andres Freund
Date:
Subject: Re: Fetch zero result rows when executing a query?