Quick Links

When is a blank not a null or ''

From:	mike <mike(at)redtux1(dot)uklinux(dot)net>
To:	pgsql-general(at)postgresql(dot)org
Subject:	When is a blank not a null or ''
Date:	2005-02-02 09:59:30
Message-ID:	1107338371.21155.13.camel@datacc
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

I have the following query (I have removed all nulls from the field as
test)

SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email <>'';

However I get loads of blank email addresses coming up

anyone any ideas

Re: When is a blank not a null or '' at 2005-02-02 10:26:57 from Alban Hertroys
Re: When is a blank not a null or '' at 2005-02-02 10:31:01 from Troels Arvin
Re: When is a blank not a null or '' at 2005-02-02 11:18:44 from Chris Green
Re: When is a blank not a null or '' at 2005-02-02 11:19:39 from Michael Kleiser
Re: When is a blank not a null or '' at 2005-02-02 11:30:10 from Sean Davis
Re: When is a blank not a null or '' at 2005-02-02 11:58:02 from Martijn van Oosterhout

	From	Date	Subject
Next Message	Jeff Davis	2005-02-02 10:16:46	Re: Wierd memory problem with Apache / PHP. Related to
Previous Message	Martijn van Oosterhout	2005-02-02 09:31:20	Re: Weird PostgreSQL crashes on FC2/FC3 64-bit