Changes in functions bittoint4 and bitfromint4 - Function bit does not work

From: Kenji Sugita <sugita(at)srapc1327(dot)sra(dot)co(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Changes in functions bittoint4 and bitfromint4 - Function bit does not work
Date: 2002-12-25 06:17:57
Message-ID: 20021225.151757.74735124.sugita@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Functions bittoint4 and bitfromint4 are renamed to int4 and bit respectively.
Int4 works well, but bit conflicts with type bit.

=# select int4(B'111');
int4
------
7
(1 row)

=# select bit(7);
ERROR: parser: parse error at or near ";" at character 14
=#

Following trial change of bki enables 'bit' function.

insert OID = 1683 ( bitx 11 1 12 f f t f i 1 1560 "23" bitfromint4 - _null_ )

=# select bitx(7);
bitx
----------------------------------
00000000000000000000000000000111
(1 row)

=#

Kenji Sugita

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kenji Sugita 2002-12-25 06:27:08 Libpq is not a shared library on Mac OS X
Previous Message pgsql-bugs 2002-12-25 04:36:24 Bug #855: pg_dump crash on linux-xfs