Mario Weilguni wrote:
>> This has been been discussed before, but Oracle behaves differently,
>> IMHO in a more correct way.
>> The following query returns NULL in PG:
>> SELECT NULL || 'fisk';
>> But in Oracle, it returns 'fisk':
>> The latter seems more logical...
> I've worked alot with oracle a few years ago and I agree, the feature
is handy 
> and makes sometimes life easier, but it's simply wrong. I heard a
while ago 
> that newer oracle versions changed this to sql - standard, is this

Unfortunately not, in Oracle's current version (
it is still that way.

I think that this Oracle 'feature' is almost as terrible as the
fact that they treat '' as NULL, which is (as has been pointed
out) most likely the reason for treating NULL as '' in ||.

Laurenz Albe

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to