From: | Geoff Winkless <pgsqladmin(at)geoff(dot)dj> |
---|---|
To: | sridhar bamandlapally <sridhar(dot)bn1(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: <empty string> Vs NULL |
Date: | 2015-02-09 12:57:19 |
Message-ID: | CAEzk6ffJoJmS+3aNd8fSa9H05ouSs_PiXYR2_kD2pBH4j9No1A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-performance |
On 9 February 2015 at 12:48, Geoff Winkless <pgsqladmin(at)geoff(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Mamin | 2015-02-09 13:02:06 | Re: [PERFORM] <empty string> Vs NULL |
Previous Message | Geoff Winkless | 2015-02-09 12:48:51 | Re: [ADMIN] <empty string> Vs NULL |
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Mamin | 2015-02-09 13:02:06 | Re: [PERFORM] <empty string> Vs NULL |
Previous Message | Geoff Winkless | 2015-02-09 12:48:51 | Re: [ADMIN] <empty string> Vs NULL |