[MonetDB-users] Function overloading
Hi, I am trying to create an overloaded iif function, so I created these custom functions: 1. create function iifnew(tv timestamp, fv timestamp, cond boolean) returns timestamp begin if cond then return tv; else return fv; end if; end 2. create function iifnew(tv int, fv int, cond boolean) returns int begin if cond then return tv; else return fv; end if; end 3. create function iifnew(tv string, fv string, cond boolean) returns string begin if cond then return tv; else return fv; end if; end But now, if I do something like this: update table1 set "Column1" = iifnew('hello1', 'hello2', ("Column2" = "Column3")) I get this: !SQLException:int:conversion of string 'hello1' failed Is this a bug in function overloading? I am running Feb2009 from CSV on Windows. Thanks. -- View this message in context: http://www.nabble.com/Function-overloading-tp25210862p25210862.html Sent from the monetdb-users mailing list archive at Nabble.com.
participants (1)
-
Alex Bo.