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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-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

Browse pgadmin-hackers by date

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

Browse pgsql-hackers by date

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