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.