thanks for this. I did get it to work using coalesce and nullif on opposite sides of the where condition, but the IS DISTINCT FROM certainly sounds a better approach. Coming from SQLServer until last year , never came across it before
Mike On Wed, 19 Dec 2018 at 10:57, Arnaud L. <arnaud.lis...@codata.eu> wrote: > Le 19/12/2018 à 11:41, Mike Martin a écrit : > > cast(nullif(d.joineddate,NULL) as timestamp) != > cast(nullif(s.joineddate,'') as timestamp) > Try with > d.joineddate IS DISTINCT FROM s.joineddate > > https://www.postgresql.org/docs/current/functions-comparison.html > > Cheers > -- > Arnaud > >
