Josh Berkus wrote:
> On 5/21/09 6:44 PM, Alvaro Herrera wrote:
>> Josh Berkus wrote:
>>>> 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.
>>
>> Would this be best served by implementing PL/TSQL?
>
> Passing variables takes place *outside* of the PL.
Hmm, sure, but I was actually thinking on a higher level ... I mean I've always
thought that there's so much effort directed at porting procedures from TSQL to
plpgsql, but it would be better to just write a dedicated PL. (Of course,
the set of people who can actually write such a PL is a lot smaller than those
who can write plpgsql).
I mean if all you had to do was change = to "as" to make your TSQL procedures
supported, you'd be a lot happier than if that was the only work you could
_save_.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
