Re: When is a blank not a null or ''
От
Troels Arvin
Тема
Re: When is a blank not a null or ''
Дата
Msg-id
pan.2005.02.02.10.31.01.33278@arvin.dk
Список
Дерево обсуждения
Re: When is a blank not a null or '' Troels Arvin <troels@arvin.dk>
Re: When is a blank not a null or '' mike <mike@redtux1.uklinux.net>
Re: When is a blank not a null or '' Michael Kleiser <mkl@webde-ag.de>
On Wed, 02 Feb 2005 09:59:30 +0000, mike wrote: > 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 An idea: You have " "-values in your work_email column, i.e. work_email values consisting of space(s). -- Greetings from Troels Arvin, Copenhagen, Denmark
В списке pgsql-general по дате отправления
