Hi,
Please take this to another list, this has little to do with
PostgreSQL admin or performance.
Florent
On Tue, Feb 10, 2015 at 4:53 AM, sridhar bamandlapally
wrote:
> In application code is
>
> while inserting/updating: INSERT/UPDATE into ... ( '' ) - which is empty
> string in PG, and in
In application code is
while inserting/updating: INSERT/UPDATE into ... ( '' ) - which is empty
string in PG, and in Oracle its NULL
while selecting: SELECT ... WHERE column IS NULL / NOT NULL
the issue is, while DML its empty string and while SELECT its comparing
with NULL
On Mon, Feb 9,
>>Hi
>>
>>2015-02-09 12:22 GMT+01:00 sridhar bamandlapally :
>>
>>Hi All
>>
>>We are testing our Oracle compatible business applications on PostgreSQL
>> database,
>>
>>the issue we are facing is Vs NULL
>>
>>In Oracle '' () and NULL are treated as NULL
>>
>>but, in PostgreSQ
Its been a while since I really worked with Postgres, but could you write a
trigger to convert empty string to null on save? You'd have to carefully
apply it everywhere but it'd get you the searching for null finds empty. If
that is all you do the you've got it.
Essentially, there isn't a switch
Hi
2015-02-09 12:22 GMT+01:00 sridhar bamandlapally :
> Hi All
>
> We are testing our Oracle compatible business applications on PostgreSQL
> database,
>
> the issue we are facing is Vs NULL
>
> In Oracle '' () and NULL are treated as NULL
>
> but, in PostgreSQL '' not treated as NULL
>
> I nee
Hi All
We are testing our Oracle compatible business applications on PostgreSQL
database,
the issue we are facing is Vs NULL
In Oracle '' () and NULL are treated as NULL
but, in PostgreSQL '' not treated as NULL
I need some *implicit* way in PostgreSQL where '' can be
treated as NULL
Please
