Re: BUG #1922: bit string of calculated length - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1922: bit string of calculated length
Date
Msg-id 20497.1128089496@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1922: bit string of calculated length  ("Sorin Schwimmer" <sxn02@yahoo.com>)
List pgsql-bugs
"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

pgsql-bugs by date:

Previous
From: "Søren Vainio"
Date:
Subject: BUG #1925: upper() and lower() fails with non-english char.
Next
From: Devrim GUNDUZ
Date:
Subject: Re: BUG #1926: /etc/init.d/postgresql - script version 7.4.5