BUG #1922: bit string of calculated length

Поиск
Список
Период
Сортировка
От Sorin Schwimmer
Тема BUG #1922: bit string of calculated length
Дата
Msg-id 20050929164737.BFCC6F107C@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #1922: bit string of calculated length  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      1922
Logged by:          Sorin Schwimmer
Email address:      sxn02@yahoo.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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [patch] krb5 authentication on multihomed server hosts
Следующее
От: "Kevin Waldron"
Дата:
Сообщение: BUG #1926: /etc/init.d/postgresql - script version 7.4.5 fails on startup