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
