Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Vs NULL - Mailing list pgsql-performance

From Geoff Winkless
Subject Re: [ADMIN] Vs NULL
Date
Msg-id CAEzk6ffJoJmS+3aNd8fSa9H05ouSs_PiXYR2_kD2pBH4j9No1A@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] Vs NULL  (Geoff Winkless <pgsqladmin@geoff.dj>)
List pgsql-performance
Tree view
On 9 February 2015 at 12:48, Geoff Winkless <pgsqladmin@geoff.dj> 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_elements005.htm#SQLRF30037


Note:Oracle Database currently treats a character value with a length of zero as null. However, this may not continue to be true in future releases, and Oracle recommends that you do not treat empty strings the same as nulls.


Geoff​
 

pgsql-performance by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: [ADMIN] Vs NULL
Next
From: TonyS
Date:
Subject: Migrating a FoxPro system and would like input on the best way to achieve optimal performance