Re: phone number list
Adrian Holovaty <postgres@holovaty.com>
From: Adrian Holovaty <postgres@holovaty.com>
To: Bryan Irvine <bryan.irvine@kingcountyjournal.com>
Cc: pgsql-novice@postgresql.org
Date: 2003-09-10T19:45:27Z
Lists: pgsql-novice
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