Re: phone number list
От
Adrian Holovaty
Тема
Re: phone number list
Дата
Msg-id
200309101445.27160.postgres@holovaty.com
Ответ на
Re: phone number list (Bryan Irvine)
Список
Дерево обсуждения
phone number list Bryan Irvine <bryan.irvine@kingcountyjournal.com>
Re: phone number list "Louise Cofield" <lcofield@box-works.com>
Re: phone number list Oliver Elphick <olly@lfix.co.uk>
Re: phone number list Bryan Irvine <bryan.irvine@kingcountyjournal.com>
Re: phone number list Adrian Holovaty <postgres@holovaty.com>
Re: phone number list Bryan Irvine <bryan.irvine@kingcountyjournal.com>
Re: phone number list Jeff Eckermann <jeff_eckermann@yahoo.com>
Re: phone number list Bruno Wolff III <bruno@wolff.to>
Re: phone number list <ghaverla@freenet.edmonton.ab.ca>
Bryan Irvine wrote:
> insert into phonenumbers values (425, 888, 0773);
>
> dncl=# select * from phonenumbers;
> areacode | prefix | suffix
> ----------+--------+--------
> 425 | 888 | 773
>
> Any ideas? Do I need to change the format of the fields again?
Put quotes around the values you're inserting, like this:
INSERT INTO phonenumbers VALUES ('425', '888', '0773');
HTH,
Adrian
В списке pgsql-novice по дате отправления
