pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedOperation on bit strings with different length
3+ messages / 3 participants
[nested] [flat]
* Operation on bit strings with different length
@ 2001-12-18 05:33 S P Arif Sahari Wibowo <arifsaha@yahoo.com>
2001-12-18 16:37 ` Re: Operation on bit strings with different length Josh Berkus <josh@agliodbs.com>
2001-12-18 22:23 ` Re: Operation on bit strings with different length Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 3+ messages in thread
From: S P Arif Sahari Wibowo @ 2001-12-18 05:33 UTC (permalink / raw)
To: pgsql-sql; pgsql-novice@postgresql.org
Hi!
Do you know how to operate (AND, OR, etc.) on bit strings with
dynamically different length? It is dynamic, means the length won't be
determined until run time.
Is there any function to extend the length of a bit string to a certain
length?
Thank you!
--
S P Arif Sahari Wibowo
_____ _____ _____ _____
/____ /____/ /____/ /____ arifsaha@yahoo.com
_____/ / / / _____/ http://www.arifsaha.com/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Operation on bit strings with different length
2001-12-18 05:33 Operation on bit strings with different length S P Arif Sahari Wibowo <arifsaha@yahoo.com>
@ 2001-12-18 16:37 ` Josh Berkus <josh@agliodbs.com>
1 sibling, 0 replies; 3+ messages in thread
From: Josh Berkus @ 2001-12-18 16:37 UTC (permalink / raw)
To: S P Arif Sahari Wibowo <arifsaha@yahoo.com>; pgsql-novice@postgresql.org
Arif,
For future notice, the NOVICE list is the appropriate place for this
type of question.
> Do you know how to operate (AND, OR, etc.) on bit strings with
> dynamically different length? It is dynamic, means the length won't
> be
> determined until run time.
> Is there any function to extend the length of a bit string to a
> certain
> length?
PostgreSQL is currently (as far as I know) lacking a good set of bitwise
data types and operators. If you really need to use them, I suggest
that you construct them -- Postgres allows you to build your own data
types, and operators for those data types. It's a somewhat
labor-intensive process.
Most of us don't have much use for bitwise operations in the database,
because the essential intent of a bitwise number is to store several
different pieces of data in the same number. This goes against
relational principles, which say that each field should be "atomic";
that is, containing one and only one piece of information.
If, however, you are interacting with the MS API, I can see why you
would need bitwise logic. So my suggestions are:
1. Create your own data types and operators per paragraph 1;
2. Just store the integer in Postgres, and do your bitwise logic in your
interface/middleware language.
-Josh Berkus
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Operation on bit strings with different length
2001-12-18 05:33 Operation on bit strings with different length S P Arif Sahari Wibowo <arifsaha@yahoo.com>
@ 2001-12-18 22:23 ` Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2001-12-18 22:23 UTC (permalink / raw)
To: S P Arif Sahari Wibowo <arifsaha@yahoo.com>; +Cc: pgsql-sql
S P Arif Sahari Wibowo writes:
> Do you know how to operate (AND, OR, etc.) on bit strings with
> dynamically different length? It is dynamic, means the length won't be
> determined until run time.
> Is there any function to extend the length of a bit string to a certain
> length?
Something along the lines of
SUBSTRING ( your_value || B'000000000000...long enough...000' FROM 1 FOR max_length )
The reason this is not done automatically is that it's not clear whether
the extension should be to the left or to the right. Either of these
could be appropriate, depending on whether you consider bit strings to be
strings or numbers. Once you know what you want in your application you
can wrap the above into a function. To generate a generic "long enough"
value, look at the REPEAT function.
--
Peter Eisentraut peter_e@gmx.net
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-12-18 22:23 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-12-18 05:33 Operation on bit strings with different length S P Arif Sahari Wibowo <arifsaha@yahoo.com>
2001-12-18 16:37 ` Josh Berkus <josh@agliodbs.com>
2001-12-18 22:23 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox