Skip site navigation (1) Skip section navigation (2)

BUG #1922: bit string of calculated length

From: "Sorin Schwimmer" <sxn02(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1922: bit string of calculated length
Date: 2005-09-29 16:47:37
Message-ID: 20050929164737.BFCC6F107C@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1922
Logged by:          Sorin Schwimmer
Email address:      sxn02(at)yahoo(dot)com
PostgreSQL version: 8.0.2
Operating system:   Gentoo Linux 2005
Description:        bit string of calculated length
Details: 

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.
The following experiments should prove my point:
SELECT '0'::BIT(20-4);
SELECT '0'::BIT(10+2);

I'd like to suggest to allow for any expression that converts to positive
integer.

Thanks,
Sorin Schwimmer

Responses

pgsql-bugs by date

Next:From: Sorin SchwimmerDate: 2005-09-29 16:54:49
Subject: BUG #1923: infinity arithmetic errors
Previous:From: j6mDate: 2005-09-29 15:02:39
Subject: Re: BUG #1921: NULL<>NULL ?!?!?!?!?!?!?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group