Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2 - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2
Date
Msg-id 162867790905211206s1d96379br706fb5382ce7c6ab@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
2009/5/21 Pavel Stehule <pavel.stehule@gmail.com>:
> 2009/5/21 Josh Berkus <josh@agliodbs.com>:
>>
>>> 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2
Next
From: Steve Prentice
Date:
Subject: Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2