Search Postgresql Archives

Re: New.* and old.* as function arguments within rules

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On 12/03/2005 10:29:43 PM, Tom Lane wrote:
"Karl O. Pinc" <kop@xxxxxxxx> writes:
> 2nd, nowhere have I found a NEW.* syntax (as written).

In general, "foo.*" where foo is a visible table alias is meaningful
anywhere that a rowtype value would be accepted.  There is a special
case at the top level of a SELECT result list, where it will be broken
apart into a list of foo's component fields because the SQL spec says
so.

Thanks very much.  I had just started writing 'foo' because I didn't
know about 'foo.*' and it's been working so far (8.0.3) but
would _hate_ to have it break on upgrade.

This is the first time I've found the Postgres documentation to be
really lacking.  I suppose there has to be a first.
(Very sorry, _wway_ to busy to write a doc patch.)

Karl <kop@xxxxxxxx>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux