Received: from pacific.usa.dp.ua (onyx.extrasy.net [195.248.166.227]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9PIM8P12116; Thu, 25 Oct 2001 14:22:10 -0400 (EDT) (envelope-from green@pacific.usa.dp.ua) Received: (from green@localhost) by pacific.usa.dp.ua (8.9.3/8.9.3) id VAA80832; Thu, 25 Oct 2001 21:25:33 +0300 (EEST) (envelope-from green) Date: Thu, 25 Oct 2001 21:25:33 +0300 From: Alexey Prohorenko To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: [LONGINT] Problem Message-ID: <20011025212533.A80805@usa.dp.ua> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0.1i X-Archive-Number: 200110/1081 X-Sequence-Number: 16882 Hi, Guys, I am new to PostgreSQL -- (I am migrating from MySQL), so I have some, may be "stupid", but still interesting questions. Interesting for me. :-) In MySQL there was type called INT UNSIGNED, where I used to keep values from 1 to 4294967295 without any problems. 1 is '00000000000000000000000000000001' in binary, and 4294967295 is '11111111111111111111111111111111'. I also was able to do f.e. 'SELECT xxx WHERE (xxx & 2147483648)' and get everything I want. 2147483648 is '10000000000000000000000000000000' in binary. Nevertheless, with PostgreSQL I have troubles. I didn't find any type which will help me to do everything above mentioned. May be someone of you was in the same situation, or has enough knowledge to help me with that? I'll be very gladfull for any answer, Looking forward them. Thanks. P.S. If possible -- do CC: green@usa.dp.ua when answering, cause I am not sure does Majordomo subscribe me or not. :-) -- green [http://www.extrasy.net]