Thread: Delete function without knowing the elements

Delete function without knowing the elements

From
Peter Atkins
Date:
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



Re: Delete function without knowing the elements

From
"Marie G. Tuite"
Date:
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)
>