Re: Name column

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Name column
Дата
Msg-id AANLkTim6nmbPuC_fWo2EgG4EdY8C08qV9tTjRLnAzk3h@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Name column  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
2010/9/24 Tom Lane <tgl@sss.pgh.pa.us>:
> Robert Haas <robertmhaas@gmail.com> writes:
>> On Fri, Sep 24, 2010 at 11:43 AM, Tom Lane <tgl@sss.pgh.pa.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Name column
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Serializable Snapshot Isolation