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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers