problems with leading zero's
| От | Bryan Irvine |
|---|---|
| Тема | problems with leading zero's |
| Дата | |
| Msg-id | 1069268842.2056.11.camel@elvis.horvitznewspapers.net обсуждение исходный текст |
| Ответы |
Re: problems with leading zero's
Re: problems with leading zero's |
| Список | pgsql-novice |
I'm having problems with my SQL selecting numbers with preceding zero's
from a character field.
I'm creating the fields like this:
CREATE TABLE phonenumbers (
areacode character varying(3),
prefix character varying(3),
suffix character varying(4)
);
when I run a broad select based on areacode and prefix i get this
(numbers munged to protect the innocent)
select * from phonenumbers where areacode = 555 and prefix = 555;
areacode | prefix | suffix
----------+--------+--------
555 | 555 | 0044
555 | 555 | 0049
...etc
but when i try to do a more exact search for a number with a suffix that
starts with a zero, nothing comes back.
select * from phonenumbers where areacode = 865 and prefix = 379 and \
suffix = 0044;
areacode | prefix | suffix
----------+--------+--------
(0 rows)
Ideas?
--Bryan
В списке pgsql-novice по дате отправления: