Postgres Pro
Downloads
Home   >   mailing lists

When is a blank not a null or '' - Mailing list pgsql-general

From mike
Subject When is a blank not a null or ''
Date
Msg-id 1107338371.21155.13.camel@datacc
Whole thread Raw
Responses Re: When is a blank not a null or ''  (Alban Hertroys <alban@magproductions.nl>)
Re: When is a blank not a null or ''  (Michael Kleiser <mkl@webde-ag.de>)
Re: When is a blank not a null or ''  (Sean Davis <sdavis2@mail.nih.gov>)
Re: When is a blank not a null or ''  (Chris Green <chris@areti.co.uk>)
Re: When is a blank not a null or ''  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Weird PostgreSQL crashes on FC2/FC3 64-bit
Next
From: Jeff Davis
Date:
Subject: Re: Wierd memory problem with Apache / PHP. Related to