Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2

Поиск
Список
Период
Сортировка
Искать
От
Pavel Stehule
Тема
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2
Дата
в 16:06:25
Msg-id
162867790905211206s1d96379br706fb5382ce7c6ab@mail.gmail.com
Ответ на
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2 (Pavel Stehule)
Список
Дерево обсуждения
[PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2 Steve Prentice <prentice@cisco.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2 Pavel Stehule <pavel.stehule@gmail.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v3 Steve Prentice <prentice@cisco.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v3 Bernd Helmle <mailings@oopsware.de>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v3 Steve Prentice <prentice@cisco.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v3 Robert Haas <robertmhaas@gmail.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v3 Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v3 Pavel Stehule <pavel.stehule@gmail.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v3 Steve Prentice <prentice@cisco.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v3 Pavel Stehule <pavel.stehule@gmail.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v3 Robert Haas <robertmhaas@gmail.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v3 Robert Haas <robertmhaas@gmail.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2 Josh Berkus <josh@agliodbs.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2 Pavel Stehule <pavel.stehule@gmail.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2 Pavel Stehule <pavel.stehule@gmail.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2 Alvaro Herrera <alvherre@commandprompt.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2 Josh Berkus <josh@agliodbs.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2 Alvaro Herrera <alvherre@commandprompt.com>
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2 Steve Prentice <prentice@cisco.com> 
2009/5/21 Pavel Stehule :
> 2009/5/21 Josh Berkus :
>>
>>> The patch adds the "AS" keyword to the plpgsql grammar and doesn't
>>> assign an expression parameter to the sql construct if the scalar
>>> follows the AS keyword.
>>
>> Would it be possible to also support "=" as well as "as"?  I believe that
>> SQL Server uses "=" exclusively, and supporting that syntax would help
>> people port TSQL-based applications.
>>
>
> No, it not possible, or not simply . This is ambiguous. a = 10 should
> be normal boolean expression. I didn't use T-SQL many years, but I
> thing, so in T-SQL this problem is solved with variables prefixes @.

there are not technical problem - there are semantic problem

Pavel

>
> regards
> Pavel Stehule
>
>> --
>> Josh Berkus
>> PostgreSQL Experts Inc.
>> www.pgexperts.com
>>
>> --
>> 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 по дате отправления
Предыдущее
От: Pavel Stehule
Дата:
Следующее
От: Steve Prentice
Дата:
FAQ