Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7C9A1475BF7
	for <pgsql-sql@postgresql.org>; Tue, 13 Aug 2002 13:20:48 -0400 (EDT)
Received: from nxcdmail.nxcd.com (nxcdmail.nxcd.com [65.213.43.194])
	by postgresql.org (Postfix) with ESMTP id E57F5475BC1
	for <pgsql-sql@postgresql.org>; Tue, 13 Aug 2002 13:20:47 -0400 (EDT)
Received: by NXCDMAIL with Internet Mail Service (5.5.2653.19)
	id <QTAWQVFR>; Tue, 13 Aug 2002 10:29:44 -0700
Message-ID: <1CAD483B723BD611B0C10090274FF0685547ED@NXCDMAIL>
From: Peter Atkins <peter.atkins@NXCD.com>
To: pgsql-sql@postgresql.org
Subject: Delete function without knowing the elements
Date: Tue, 13 Aug 2002 10:29:43 -0700
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/204
X-Sequence-Number: 9050

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