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

From Steve Prentice
Subject Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2
Date
Msg-id A29A66E8-88B2-4D50-9DB9-12BB67429723@cisco.com
Whole thread Raw
In response to Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
"=" is more common than "as" for sure, but this has been talked about  
before starting at about this message:

http://archives.postgresql.org/message-id/14319.1228833321@sss.pgh.pa.us

-Steve

On May 21, 2009, at 11:51 AM, 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.

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com



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: Alvaro Herrera
Date:
Subject: Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2