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	February 2, 2005 12:59:37
Msg-id	1107338371.21155.13.camel@datacc Whole thread Raw
Responses	Re: When is a blank not a null or '' Re: When is a blank not a null or '' Re: When is a blank not a null or '' Re: When is a blank not a null or '' Re: When is a blank not a null or ''
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:

From: Martijn van Oosterhout
Date: 02 February 2005, 12:31:37
Subject: Re: Weird PostgreSQL crashes on FC2/FC3 64-bit

From: Jeff Davis
Date: 02 February 2005, 13:17:03
Subject: Re: Wierd memory problem with Apache / PHP. Related to

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

Previous

Next