Re: Fetch zero result rows when executing a query?

Поиск
Список
Период
Сортировка
От Marko Tiikkaja
Тема Re: Fetch zero result rows when executing a query?
Дата
Msg-id 54D20589.1010505@joh.to
обсуждение исходный текст
Ответ на 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?
Список pgsql-hackers
On 2/4/15 12:36 PM, Stephen R. van den Berg wrote:
> Marko Tiikkaja wrote:
>> This seems to be a common pattern, and I think it's a *huge* mistake
>> to specify maxrows=1 and/or ignore rows after the first one in the
>> driver layer.  If the user says "give me the only row returned by
>
> I guess it depends on the amount of backpressure you can excert on
> the sql "programmer".
> If you are writing a driver which just has to run applications
> written by third parties in the most efficient way, the outline
> I gave above is best.
> If the driver has a way to communicate with the one writing
> the SQL, then giving warnings is better.

Screw warnings, that should be an error.  "I tried to execute your 
query, but something went wrong."

Anyway, this is getting really off topic now, and that's my fault, so I 
should shut up.


.m



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

Предыдущее
От: "Stephen R. van den Berg"
Дата:
Сообщение: Re: Fetch zero result rows when executing a query?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Unnecessary pointer-NULL checks in pgp-pgsql.c