Mario Weilguni wrote: >> This has been been discussed before, but Oracle behaves differently, and >> IMHO in a more correct way. >> >> The following query returns NULL in PG: >> SELECT NULL || 'fisk'; >> >> But in Oracle, it returns 'fisk': >> SELECT NULL || 'fisk' FROM DUAL; >> >> 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 true?
Unfortunately not, in Oracle's current version (10.2.0.2.0) 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 ||. Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
