Bug or my crooked hands? - Mailing list 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@vpcit.ru