Re: Proposal for updatable views - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Proposal for updatable views
Date
Msg-id 44167C6B.2070809@dunslane.net
Whole thread Raw
In response to Re: Proposal for updatable views  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

>Worst case is we promote WITH to a fully reserved word.  While I don't
>normally care for doing that, it *is* a reserved word per SQL99, and
>offhand I don't see likely scenarios for someone using "with" as a table
>or column or function name.  (Anyone know of a language in which "with"
>is a noun or verb?)
>
>  
>

If we eventually support a WITH clause for recursive queries I suspect 
we won't have much choice anyway. I could imagine someone using "with" 
as a column name, but I can't see how to avoid hurting those people.

cheers

andrew


pgsql-hackers by date:

Previous
From: "William ZHANG"
Date:
Subject: Re: Proposal for updatable views
Next
From: Simon Riggs
Date:
Subject: Re: log_duration and log_statement