Hi there, How can I test the type of a parameter passed to a function via ANY data type? I want something like this:
CREATE OR REPLACE FUNCTION myfunction(_param ANY) RETURNS INTEGER AS $$ BEGIN IF "_param IS OF INTEGER TYPE" THEN -- do something with INTEGER END IF; IF "param is of BOOLEAN TYPE" THEN -- do something with BOOLEAN END IF; RETURN; END; $$ LANGUAGE plpgsql; Thanks, Nosy ---------------------------(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