Re: Name column

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, André Fernandes <andre(dot)de(dot)camargo(dot)fernandes(at)hotmail(dot)com>, heikki(dot)linnakangas(at)enterprisedb(dot)com, arhipov(at)dc(dot)baikal(dot)ru, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Name column
Date: 2010-09-24 16:16:57
Message-ID: AANLkTim6nmbPuC_fWo2EgG4EdY8C08qV9tTjRLnAzk3h@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2010/9/24 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>> On Fri, Sep 24, 2010 at 11:43 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> -1.  There's nothing wrong with the function-as-a-computed-column
>>> feature, and it seems likely that taking it away will break applications.
>
>> ... What evidence do we have that anyone is relying on this
>> behavior in applications?  Every report I've heard of it involved
>> someone being surprised that it worked that way.
>
> 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
> satisfied users.
>
> The reason people don't know about this feature is that it's so poorly
> documented --- there's just one mention buried deep in chapter 35 of
> the manual, in a place where most people wouldn't think to look for it.
> I'm not quite sure where's a better place though.

I hope so nobody use it. It is absolutely out of standard. It is like
own syntax of mysql for some SQL statements like own INSERT. Some
people talked so these specialities are useful too.

Regards

Pavel Stehule
>
>                        regards, tom lane
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2010-09-24 16:17:51 Magnus? Is that you?
Previous Message Tom Lane 2010-09-24 16:16:09 Re: Name column