|| at Sep 24, 2010 at 4:11 pm
Robert Haas writes:
On Fri, Sep 24, 2010 at 11:55 AM, Tom Lane wrote:
So? There are lots of surprising things in SQL. And *of course* the
only complaints come from people who didn't know about it, not from
I guess that's true, but is this behavior specified in or required by
any SQL standard? Are there other database products that also support
this syntax? Or is this just our own invention?
It's a holdover from PostQUEL, I think, but it's still useful. I
observe that SQL:2008 has added a significantly-uglier-than-this feature
for computed columns, so there's certainly use cases out there.
I think it's because it's counterintuitive.
From an object-oriented-programming standpoint it seems entirely
intuitive. Many OOP languages minimize the notational difference
between members and methods of a class.
regards, tom lane