Skip site navigation (1) Skip section navigation (2)

Re: What about CREATE OR REPLACE FUNCTION?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: What about CREATE OR REPLACE FUNCTION?
Date: 2001-10-02 16:27:19
Message-ID: 200110021627.f92GRJF12594@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-hackers
> Did we come to any conclusion about whether to accept Gavin Sherry's
> CREATE OR REPLACE FUNCTION patch?
> http://fts.postgresql.org/db/mw/msg.html?mid=1035792
> 
> AFAIR, the score was that I liked it, Bruce didn't, and no one else
> had expressed an opinion.

I withdraw my objection.  When I read it, I thought we were going to
have CREATE FUNCTION and REPLACE FUNCTION.  I later realized it is
literally CREATE OR REPLACE FUNCTION.  Looks strange, but there is no
standard way to do this and we usually take the Oracle syntax when the
standard doesn't specify it.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-10-02 16:29:08
Subject: Re: do we're in time to catch 7.2 Beta ?
Previous:From: Bruce MomjianDate: 2001-10-02 16:14:10
Subject: Re: CVS changes

pgadmin-hackers by date

Next:From: Stephan SzaboDate: 2001-10-02 16:41:23
Subject: Re: What about CREATE OR REPLACE FUNCTION?
Previous:From: Dave PageDate: 2001-10-02 16:23:46
Subject: Re: Column lenght

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group