[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] [ADMIN] <empty string> Vs NULL
From:       Geoff Winkless <pgsqladmin () geoff ! dj>
Date:       2015-02-09 12:57:19
Message-ID: CAEzk6ffJoJmS+3aNd8fSa9H05ouSs_PiXYR2_kD2pBH4j9No1A () mail ! gmail ! com
[Download RAW message or body]

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​

[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_default" \
style="font-family:verdana,sans-serif;font-size:small"><span \
style="font-family:arial,sans-serif">On 9 February 2015 at 12:48, Geoff Winkless \
</span><span dir="ltr" style="font-family:arial,sans-serif">&lt;<a \
href="mailto:pgsqladmin@geoff.dj" \
target="_blank">pgsqladmin@geoff.dj</a>&gt;</span><span \
style="font-family:arial,sans-serif"> wrote:</span></div><div \
class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" \
style="margin:0px 0px 0px \
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div \
dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><div \
style="font-family:verdana,sans-serif">Oracle&#39;s own documentation suggests that \
developers should not rely on this behaviour since it may change in the \
future.</div><div style="font-family:verdana,sans-serif"><br></div></div></div></div></blockquote><div><div \
class="gmail_default" \
style="font-family:verdana,sans-serif;font-size:small;display:inline">​</div><span \
style="font-family:verdana,sans-serif">Just in case you&#39;re looking for \
it:</span></div><div class="gmail_default" \
style="font-family:verdana,sans-serif"><br></div><div class="gmail_default"><font \
face="verdana, sans-serif"><a \
href="http://docs.oracle.com/database/121/SQLRF/sql_elements005.htm#SQLRF30037">http:/ \
/docs.oracle.com/database/121/SQLRF/sql_elements005.htm#SQLRF30037</a></font><br></div><div \
class="gmail_default"><font face="verdana, sans-serif"><br></font></div><div \
class="gmail_default"><br></div><div class="gmail_default"><p class="" \
style="padding:0px 0px 4px 28px;font-family:&#39;Helvetica Neue&#39;,&#39;Neue \
Helvetica&#39;,Arial,sans-serif;font-weight:bold;font-size:18px;line-height:1.4;color: \
rgb(28,89,170);max-width:90em;background:url(http://docs.oracle.com/database/121/dcommon/img/note.png) \
2px 5px no-repeat scroll rgba(0,0,0,0)">Note:</p><span \
style="font-family:&#39;Helvetica Neue&#39;,&#39;Neue \
Helvetica&#39;,Arial,sans-serif;font-size:14px;line-height:21px;background-color:rgb(239,246,254)">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.</span><font face="verdana, \
sans-serif"><br></font></div><div class="gmail_default"><span \
style="font-family:&#39;Helvetica Neue&#39;,&#39;Neue \
Helvetica&#39;,Arial,sans-serif;font-size:14px;line-height:21px;background-color:rgb(239,246,254)"><br></span></div><div><div \
class="gmail_default" \
style="font-family:verdana,sans-serif;font-size:small;display:inline">Geoff​</div>  \
</div></div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]