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