[EMAIL PROTECTED] writes:
> foobar=# select text(CASE WHEN (cashback = NULL or cashback = 0) THEN '0' ELSE
>cashback END) from transaction_payments where idnum = 139 and payment_type = 6;
> text
> ---
> 1.01855797968803e-312
> (1 row)
Try not quoting the '0'. For r
Justin Clift ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Wrong output for 7.0.3 from NULL fields in CASE statement
Long Description
I am getting output that doesn't make sense from a simple SQL statement. I am
expecting t
