"Sorin Schwimmer" <sxn02@yahoo.com> writes:
> When puting in an expression something like
> '0'::BIT(20-LENGTH(something_here))
> I receive an error message suggesting that integer arithmetic is not allowed
> in a BIT declaration.
Yup, you're right.
> I'd like to suggest to allow for any expression that converts to positive
> integer.
Don't hold your breath. This is not required by the SQL spec and it
seems much more difficult to implement than it's worth.
regards, tom lane