Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2
Date
Msg-id 4A15A2A2.4070509@agliodbs.com
Whole thread Raw
In response to [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2  (Steve Prentice <prentice@cisco.com>)
Responses Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2  (Steve Prentice <prentice@cisco.com>)
Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Tree view 
> 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: Steve Prentice
Date:
Subject: Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v3
Next
From: Pavel Stehule
Date:
Subject: Re: [PATCH] 8.5 plpgsql change for named notation: treat word following AS keyword as label v2