Hi :
I am working in a migration. Im am migrating systems based in mysql to
postgresql.
I am trying to create a function named IFNULL, to not migrate any ocurrence
of this mysql function in my code.
The IFNULL function is the same of COALESCE in postgresql.
This code does not work.
CREATE OR REPLACE FUNCTION IFNULL( xValor ANY, xPadrao ANY )
RETURNS ANY AS $$
BEGIN
RETURN COALESCE( xValor, xPadrao );
END;
$$ LANGUAGE plpgsql
CALLED ON NULL INPUT
SECURITY INVOKER;
Can you help-me to create a function that acept any data type ?
Thank in advance
Alejandro Michelin Salomon
Porto Alegre
Brasil
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.1/278 - Release Date: 9/3/2006
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.1/278 - Release Date: 9/3/2006
---------------------------(end of broadcast)---------------------------
TIP 1: 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
