Re: [PATCH] parser: optionally warn about missing AS for column and table aliases - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: [PATCH] parser: optionally warn about missing AS for column and table aliases
Date
Msg-id 540A20EE.7020109@joh.to
Whole thread Raw
In response to [PATCH] parser: optionally warn about missing AS for column and table aliases  (Oskari Saarenmaa <os@ohmu.fi>)
Responses Re: [PATCH] parser: optionally warn about missing AS for column and table aliases
Re: [PATCH] parser: optionally warn about missing AS for column and table aliases
List pgsql-hackers
On 2014-09-05 22:38, Oskari Saarenmaa wrote:
> I wrote the attached patch to optionally emit warnings when column or table
> aliases are used without the AS keyword after errors caused by typos in
> statements turning unintended things into aliases came up twice this week.
> First in a discussion with a colleague who was surprised by a 1 row result
> for the query 'SELECT COUNT(*) files' and again in the "pl/pgsql 2" thread
> as plpgsql currently doesn't throw an error if there are more result columns
> than output columns (SELECT a b INTO f1, f2).
>
> The patch is still missing documentation and it needs another patch to
> modify all the statements in psql & co to use AS so you can use things like
> \d and tab-completion without triggering the warnings.  I can implement
> those changes if others think this patch makes sense.

I think this is only problematic for column aliases.  I wouldn't want to 
put these two to be put into the same category, as I always omit the AS 
keyword for tables aliases (and will continue to do so), but never omit 
it for column aliases.


.marko



pgsql-hackers by date:

Previous
From: Oskari Saarenmaa
Date:
Subject: [PATCH] parser: optionally warn about missing AS for column and table aliases
Next
From: Oskari Saarenmaa
Date:
Subject: Re: [PATCH] parser: optionally warn about missing AS for column and table aliases