| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | dudedoe01 <marsalanaq(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: isnull() function in pgAdmin3 |
| Date: | 2016-10-03 20:09:15 |
| Message-ID: | 411c032f-dfd8-f4a3-b141-e0222ebb1371@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 03/10/16 14:39, dudedoe01 wrote:
> What is the most feasible way to emulate the below MySQL function into
> postgreSQL. Since the isnull() function is no longer supported in 9.6
> version. I have tried every trick in the hat to get the desired results.
> Still 'RPG INV' doesn't show only the other two then options show up.
>
> (case
> when
> ((`s`.`Funding_Date` = '')
> and (isnull(`s`.`Actual_Close_Date`)
> or (`s`.`Actual_Close_Date` = '')))
<snip>
Maybe I missed something earlier in the thread (only tuned in now), but
what's wrong with
... and s.actual_close_date is null ....
?
Ray.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | otar shavadze | 2016-10-03 20:16:36 | Re: [GENERAL] Understanding “max_wal_size” and “min_wal_size” parameters default values from postgresql.conf file |
| Previous Message | Adrian Klaver | 2016-10-03 20:07:24 | Re: isnull() function in pgAdmin3 |