Subject Re: [firebird-support] COALESCE and gpre in FB 1.5.1
Author Helen Borrie
At 10:55 AM 20/08/2004 -0400, you wrote:
>I've submitted this bug, #1012895, along with an ESQL C program that
>demostrates the problem.
>I also downloaded the FB source and poked briefly around the gpre
>souce directory. There is no COALESCE in the parser code, nor NULLIF. There
>is a CASE, but no matching WHEN. Sure enough, attempting to substitute CASE
>for COALESCE in ESQL, with or without WHEN, fails.

:-( Probably NULLIF, too, then. What about SUBSTRING?

I'm sure nobody will mind if you want to mod gpre. :-) I looked at the
source and it reminded me of my son's bedroom...