Re: [PERFORM] [ADMIN] Vs NULL

2015-02-09 Thread Geoff Winkless
On 9 February 2015 at 12:48, Geoff Winkless wrote: > Oracle's own documentation suggests that developers should not rely on > this behaviour since it may change in the future. > > ​ Just in case you're looking for it: http://docs.oracle.com/database/121/SQLRF/sql_elem

Re: [PERFORM] [ADMIN] Vs NULL

2015-02-09 Thread Geoff Winkless
On 9 February 2015 at 11:22, sridhar bamandlapally wrote: > the issue we are facing is Vs NULL > > In Oracle '' () and NULL are treated as NULL > > but, in PostgreSQL '' not treated as NULL > > I need some *implicit* way in PostgreSQL where '' can be > treated as NULL > > ​ The Right Thing to d