Use \df function_name to get the argument list and then drop it. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Atkins > Sent: Tuesday, August 13, 2002 12:30 PM > To: [EMAIL PROTECTED] > 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 [EMAIL PROTECTED]) >
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
