Re: "SQL" REPLACE SYNTAX

On Wed, 23 Jan 2002, Josh Berkus wrote:

> Folks,
>
> You can propose this syntax additon on the pgsql-sql list, which exists
>  to discuss these kinds of issues.  However, I will warn you that the
>  core developers have already rejected the REPLACE syntax once as an
>  unnecessary deviation from the SQL92 standard.
>
> There was a long discussion following that rejection, sometime last
>  summer I think, about how one could use triggers or rules to ape this
>  functionality on an INSERT statement.  See the pgsql-sql list
>  archives.
>
> You can, of course, also write the ANSI committee and propose that
>  REPLACE be added to SQL3.  Good luck.

Has it ever been brought up on hackers?  I remember the create or
replace stuff conversation, but that was regarding functions.  I
can't remember anything about insert or update.  Chris, maybe you
wanna bring it up there?  I'm going to be available only on a limited
basis the next couple of weeks or so or I would.

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================