Re: final light versions of Oracle compatibility (SQLSTATE, GREATEST, - Mailing list pgsql-patches

From Tom Lane
Subject Re: final light versions of Oracle compatibility (SQLSTATE, GREATEST,
Date
Msg-id 12643.1118335154@sss.pgh.pa.us
Whole thread Raw
In response to Re: final light versions of Oracle compatibility (SQLSTATE, GREATEST,  (Neil Conway <neilc@samurai.com>)
Responses Re: final light versions of Oracle compatibility (SQLSTATE,  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: final light versions of Oracle compatibility (SQLSTATE,  (Neil Conway <neilc@samurai.com>)
List pgsql-patches
Neil Conway <neilc@samurai.com> writes:
> Attached is a revised version of this patch. I'll apply it tonight or
> tomorrow, barring any objections.

I still find the grammar changes to be an ugly kluge --- it should be
possible to do this without introducing bogus nonterminals.

The ns push/pop operations don't appear to be correctly matched
(consider multiple WHEN clauses, a case the regression test does not
cover), nor do they surround the places where the variables are created.
It is likely that you don't need a push/pop at all; if it appears to
work now it's because the end of the block results in a pop and so
the variables disappear then anyway.

The patch is sloppy about whether free_var() is static or not.

I find the proposed change in plpgsql_ns_additem a distinct
disimprovement --- it's dubious even as a micro-optimization
and it certainly hurts legibility.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: to_timestamp overloaded to convert from Unix epoch
Next
From: Bruce Momjian
Date:
Subject: Re: final light versions of Oracle compatibility (SQLSTATE,