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

Re: CREATE OR REPLACE FUNCTION

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, pgsql-patches(at)postgresql(dot)org
Subject: Re: CREATE OR REPLACE FUNCTION
Date: 2001-09-22 15:37:17
Message-ID: 14284.1001173037@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> ... I see no reason to add this capability
> if it requires adding a new toplevel keyword.

That kind of annoys me too, but since the keyword can be made a TokenId,
it won't create any conflicts.  I think the argument of Oracle
compatibility is probably a sufficient reason to do it with this syntax.

> You could hack ALTER FUNCTION to create automatically if it
> doesn't exist,

That's considerably uglier than this alternative, wouldn't you say?
We have no other ALTER commands that work that way.

			regards, tom lane

In response to

Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2001-09-22 15:52:13
Subject: Re: CREATE OR REPLACE FUNCTION
Previous:From: Bruce MomjianDate: 2001-09-22 14:24:48
Subject: Re: CREATE OR REPLACE FUNCTION

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