Subject Re: [firebird-support] Firebird vs Postgres
Author Paul Vinkenoog
Hello Richard,

>> Declarations for the "null-enhanced" functions are in
>> ib_udf2.sql. If you keep using the existing declarations (in
>> ib_udf.sql), you get the old behaviour, where Nulls are passed
>> as empty strings.

> Only some of them have been enhanced. Reading from the top of the
> file, I see abs and acos have not been changed, but ascii_char has.

Like I wrote, only the following have been enhanced:
ascii_char, lower, *pad, *trim, substr*

So cos(null) is still 1, abs(null) is 0, etc.


Greetings,
Paul Vinkenoog