The following bug has been logged online:
Bug reference: 3861
Logged by: Marc mamin
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Linux
Description: cannot cast type smallint to bit
Details:
Hello,
This is more a feature request than a bug, but I guess there is no reason
why this should not be possible:
select 1::int2::bit(16)
=> ERROR: cannot cast type smallint to bit
I guess the correct way to workaround would be:
select (1::int4::bit(32)<<16)::bit(16)
which is a bit complicated :-)
HTH,
Marc Mamin
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
