pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Operation 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>
  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 16:37  Josh Berkus <josh@agliodbs.com>
  parent: S P Arif Sahari Wibowo <arifsaha@yahoo.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 22:23  Peter Eisentraut <peter_e@gmx.net>
  parent: S P Arif Sahari Wibowo <arifsaha@yahoo.com>
  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