Re: PERFORM effects FOUND patch (Was: I must be blind...)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: Alvaro Herrera <alvherre(at)atentus(dot)com>, Joe Conway <mail(at)joeconway(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PERFORM effects FOUND patch (Was: I must be blind...)
Date: 2002-06-15 16:28:16
Message-ID: 14572.1024158496@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

"Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)uk> writes:
> + if (estate->eval_processed != 0)
> + exec_set_found(estate, true);

To be actually useful the command would have to set FOUND to either
true or false depending on whether it computed a row or not. So the
correct patch would be more like

+ exec_set_found(estate, (estate->eval_processed != 0));

Also, changing the parameter to exec_run_select as you did is wrong.
A multi-row query should be allowed to run to completion, I'd think.

As for whether to apply it or not --- the change seems reasonable if we
were working in a vacuum. But I don't believe we invented PERFORM out
of whole cloth; surely there are other systems that we need to consider
compatibility with.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-06-15 17:39:33 Re: Mac os x
Previous Message Justin Clift 2002-06-15 16:22:39 Re: Would a PostgreSQL only hosting environment be of

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthew Tedder 2002-06-15 16:37:07 Re: Big Test Environment Feature
Previous Message mmendez 2002-06-15 16:20:21 please help me with psql!