| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | sridhar bamandlapally <sridhar(dot)bn1(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org>, pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: [PERFORM] <empty string> Vs NULL |
| Date: | 2015-02-09 11:53:16 |
| Message-ID: | CAFj8pRCg0qbpwGBwG2fqzDo=JRkWROVRpoOuPsNUtOTdtOGUqA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
Hi
2015-02-09 12:22 GMT+01:00 sridhar bamandlapally <sridhar(dot)bn1(at)gmail(dot)com>:
> Hi All
>
> We are testing our Oracle compatible business applications on PostgreSQL
> database,
>
> the issue we are facing is <empty string> Vs NULL
>
> In Oracle '' (<empty string>) and NULL are treated as NULL
>
> but, in PostgreSQL '' <empty string> not treated as NULL
>
> I need some *implicit* way in PostgreSQL where ''<empty string> can be
> treated as NULL
>
It is not possible in PostgreSQL. PostgreSQL respects ANSI SQL standard -
Oracle not.
Regards
Pavel
p.s. theoretically you can overwrite a type operators to support Oracle
behave, but you should not be sure about unexpected negative side effects.
>
> Please,
>
> Thanks
> Sridhar BN
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikolas Everett | 2015-02-09 12:36:13 | Re: <empty string> Vs NULL |
| Previous Message | sridhar bamandlapally | 2015-02-09 11:22:54 | <empty string> Vs NULL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikolas Everett | 2015-02-09 12:36:13 | Re: <empty string> Vs NULL |
| Previous Message | sridhar bamandlapally | 2015-02-09 11:22:54 | <empty string> Vs NULL |