Re: [INTERFACES] Functions vs. Columns?????

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Byron Nikolaidis <byron(dot)nikolaidis(at)home(dot)com>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Functions vs. Columns?????
Date: 2000-02-16 06:04:36
Message-ID: 38AA3DF4.A3AC0E00@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

> It seems that there should be some consistency here in the use of
> parenthesis. I don't really know how these things are handled on the
> backend, but it seems that parenthesis are the more correct way, or at
> least both should be allowed.

The ones without parens are SQL-mandated "constants" which are
translated in the parser front end into function calls (usually with
some other name for historical reasons). Other function calls, like
now(), are really that: function calls.

> Any thoughts?

Uh, sure ;)

- Thomas

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 2000-02-16 08:28:15 RE: [INTERFACES] DELETEs with jdbc
Previous Message Tom Lane 2000-02-16 05:12:45 Re: [INTERFACES] Functions vs. Columns?????