If you want to keep the same functions just do as follows
CREATE OR REPLACE FUNCTION nvl(TEXT,TEXT) RETURNS TEXT AS '
BEGIN
RETURN COALESCE($1,$2);
END;' LANGUAGE 'plpgsql';
You will have to do this for all supported data types unless you want to
put in a third parameter that would be the cast type
HTH
Darren
On Wed, 27 Aug 2003, Christian Traber wrote:
I know this functions, but I do not want to change the statements in my
old application.
So I want to make the functions with the Oracle names for compatibility.
Best regards,
Christian
Csaba Nagy wrote:
You don't need to build any function for this, you have them ready:
http://www.postgresql.org/docs/view.php?version=7.3idoc=0file=functions-conditional.html#AEN9753
http://www.postgresql.org/docs/view.php?version=7.3idoc=0file=functions-conditional.html#AEN9698
Cheers,
Csaba.
On Wed, 2003-08-27 at 09:58, Christian Traber wrote:
Hi,
I'll try to switch from Oracle to postgres for some small applications.
Is it possible to build functions like Oracle's nvl or decode with pgplsql?
How can I make a function like nvl that works for every datatype?
Best regards,
Christian
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
--
Darren Ferguson
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings