Delete function without knowing the elements

From: Peter Atkins <peter(dot)atkins(at)NXCD(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Delete function without knowing the elements
Date: 2002-08-13 17:29:43
Message-ID: 1CAD483B723BD611B0C10090274FF0685547ED@NXCDMAIL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Good 2002-08-13 18:00:13 pg_dump's octal strings -> oracle data load
Previous Message Marie G. Tuite 2002-08-13 17:29:32 Re: Delete function without knowing the elements