Re: stupid insert error
| От | 李江华 |
|---|---|
| Тема | Re: stupid insert error |
| Дата | |
| Msg-id | 20050624005401.914C566C064@smtp-hz обсуждение исходный текст |
| Ответ на | stupid insert error (David Bear <David.Bear@asu.edu>) |
| Список | pgsql-admin |
David Bear,您好!
yes.of course.
you should insert the record like this:
insert into person3 (asuid, fname, lname, addedby, addedon,
slopbucket) values ('123455', 'name', 'name', 'entered', '12/12/2004', '');
======= 2005-06-24 08:12:03 您在来信中写道:=======
>I guess I'm too stupid to see the error, but I don't understand why
>the following fails.
>
>
>insert into person3 (asuid, fname, lname, addedby, addedon,
>slopbucket) values ("123455", "name", "name", "entered", "12/12/2004", NULL);
>ERROR: column "123455" does not exist
>
>is the double quote byting me?
>--
>David Bear
>phone: 480-965-8257
>fax: 480-965-9189
>College of Public Programs/ASU
>Wilson Hall 232
>Tempe, AZ 85287-0803
> "Beware the IP portfolio, everyone will be suspect of trespassing"
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
= = = = = = = = = = = = = = = = = = = =
致
礼!
李江华
ljh1469@alibaba-inc.com
2005-06-24
В списке pgsql-admin по дате отправления: