Reply-To: <marie.tuite@edisonaffiliates.com>
From: "Marie G. Tuite" <marie.tuite@edisonaffiliates.com>
To: "Peter Atkins" <peter.atkins@NXCD.com>,
	<pgsql-sql@postgresql.org>
Subject: Re: Delete function without knowing the elements
Date: Tue, 13 Aug 2002 12:29:32 -0500
Message-ID: <IGELKLINGDMODABPOOFEMEACCGAA.marie.tuite@edisonaffiliates.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
In-reply-to: <1CAD483B723BD611B0C10090274FF0685547ED@NXCDMAIL>
Importance: Normal

Use \df function_name to get the argument list and then drop it.

> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Peter Atkins
> Sent: Tuesday, August 13, 2002 12:30 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] Delete function without knowing the elements
> 
> 
> All,
> 
> I created a function that I can't seem to delete.
> 
> [no sure how many parameters]
> 
> CREATE OR REPLACE FUNCTION insertEntry (int4, varchar, varchar, numeric,
> varchar, timestamp, varchar, int4, numeric, varchar, int4, ....,....)
> 	RETURNS INT4 AS '
> 		.................................................
> 	END;
> ' LANGUAGE 'plpgsql';
> 
> How can I delete this without knowing how many I used to create 
> it? This is
> what I used to delete others in the past.
> 
> DROP FUNCTION insertEntry(int4, varchar, varchar, ...);
> 
> Thanks,
> -pete
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>