| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | Cristian Custodio <crstian(at)terra(dot)com(dot)br>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: '' <> NULL |
| Date: | 2003-03-25 16:17:22 |
| Message-ID: | 20030325081053.B40429-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 25 Mar 2003, scott.marlowe wrote:
> > Does anybody here in this forum, and that work
> > with Oracle already resolve this?
> > Are there any way to change the PG to equal
> > '' like NULL?
>
> I don't work with Oracle, but there is a hack in the postgresql.conf file
> that lets you revert this behaviour.
>
> It is transform_null_equals. Set it to true, shut down and restart your
> database, and
transform_null_equals allows =NULL to be treated as IS NULL. It
won't help the empty string <-> NULL comparisons AFAICT.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2003-03-25 16:21:11 | Re: '' <> NULL |
| Previous Message | Laszlo Hornyak | 2003-03-25 16:17:09 | Re: PL/Java |