"Sorin Schwimmer" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly