| From: | Yury Don <yura(at)vpcit(dot)ru> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Bug or my crooked hands? |
| Date: | 2000-01-19 11:00:33 |
| Message-ID: | 16667.000119@vpcit.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello All,
I have the following situation:
CREATE TABLE "Contacts" (
"Contact" Serial,
"StuffTheir" Text,
"TheDate" datetime DEFAULT TEXT 'now',
"Subj" Text,
"CustomerId" int4,
"Agent" int4,
"ActionType" int2,
"Done" bool default false not null,
"ExecutionDate" datetime,
"Whom" int4
);
Then I have inserted data from text file and do a query
mdb=> select Contact from Contacts;
Contacts
-----------
-2112563299
-2111287024
-2110307960
-2110004687
-2109773688
-2109611925
-2108616455
...
mdb=> select Contact from Contacts where Contact=-2112563299;
Contacts
-------
(0 rows)
What is this and how to treat it?
Best regards,
Yury ICQ 11831432
mailto:yura(at)vpcit(dot)ru
| From | Date | Subject | |
|---|---|---|---|
| Next Message | J. Roeleveld | 2000-01-19 11:19:12 | Re: [GENERAL] Bug or my crooked hands? |
| Previous Message | Martin Neumann | 2000-01-19 08:50:58 | Unsigned Datatypes |