Re: Add hint for function named "is" - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Add hint for function named "is"
Date
Msg-id 4d1b7785-5c64-13a1-74ac-d0708044b08f@BlueTreble.com
Whole thread Raw
In response to Re: Add hint for function named "is"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Add hint for function named "is"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 8/12/16 1:40 PM, Tom Lane wrote:
> What this is telling us is that given input like, say,
>
>     SELECT 'foo'::character varying
>
> Bison is no longer sure whether "varying" is meant as a type name modifier
> or a ColLabel.  And indeed there is *no* principled answer to that that
> doesn't involve giving up the ability for "varying" to be a ColLabel.
> Just promoting it to a fully reserved word (which it is not today)
> wouldn't be enough, because right now even fully reserved words can be
> ColLabels.

FWIW, I've always disliked how some types could contains spaces without 
being quoted. AFAIK nothing else in the system allows that, and I don't 
see why character varying and timestamp with* should get a special pass.

I doubt we could get rid of this in CREATE TABLE, but I wonder how many 
people actually cast using the unquoted form.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461



pgsql-hackers by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: Re: Slowness of extended protocol
Next
From: Tom Lane
Date:
Subject: Re: Add hint for function named "is"