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

From: Steve Prentice <prentice(at)cisco(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2
Date: 2009-05-21 19:25:51
Message-ID: A29A66E8-88B2-4D50-9DB9-12BB67429723@cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2009-05-21 22:44:08 Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2
Previous Message Pavel Stehule 2009-05-21 19:06:19 Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2