Null... - Mailing list pgsql-general

From Mihai Gheorghiu
Subject Null...
Date
Msg-id 000301c14dcb$e0afc500$6e646464@New6.Travel
Whole thread Raw
Responses Re: Null...  (Keary Suska <hierophant@pcisys.net>)
List pgsql-general
PG7.1.2 on RH7.0

select 'a'<>null;
 ?column?
----------

(1 row)

select 'a'!=null;
 ?column?
----------

(1 row)

select 'a'=null;
 ?column?
----------
 f
(1 row)

select 'a'||null;
 ?column?
----------

(1 row)

Can someone please explain the above?


pgsql-general by date:

Previous
From: Marat Khairullin
Date:
Subject: Why the weak key is created as unique
Next
From: Bradley McLean
Date:
Subject: Re: PG mailing list problems (was Re: Support issues)