Subject | Re: [firebird-support] Firebird vs Postgres |
---|---|
Author | Paul Vinkenoog |
Post date | 2007-01-08T21:57:46Z |
Hello Richard,
ascii_char, lower, *pad, *trim, substr*
So cos(null) is still 1, abs(null) is 0, etc.
Greetings,
Paul Vinkenoog
>> Declarations for the "null-enhanced" functions are inLike I wrote, only the following have been enhanced:
>> 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.
ascii_char, lower, *pad, *trim, substr*
So cos(null) is still 1, abs(null) is 0, etc.
Greetings,
Paul Vinkenoog