Changes in functions bittoint4 and bitfromint4 - Function bit does not work - Mailing list pgsql-bugs

From Kenji Sugita
Subject Changes in functions bittoint4 and bitfromint4 - Function bit does not work
Date
Msg-id 20021225.151757.74735124.sugita@sra.co.jp
Whole thread Raw
Responses Re: Changes in functions bittoint4 and bitfromint4 - Function bit does not work
List 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

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #855: pg_dump crash on linux-xfs
Next
From: Kenji Sugita
Date:
Subject: Libpq is not a shared library on Mac OS X