Message-ID: <3AB8E69C.E2783619@topnet.de>
Date: Wed, 21 Mar 2001 18:36:28 +0100
From: Ralf Miller <ralf.miller@topnet.de>
Organization: topnet
MIME-Version: 1.0
To: pgsql-docs@postgresql.org
Subject: slight mistake in documentation
Content-Type: multipart/mixed; boundary="------------CD590358D1FF5B498A0C3C06"

Dies ist eine mehrteilige Nachricht im MIME-Format.
--------------CD590358D1FF5B498A0C3C06
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hello,

i shortly like to give You a hint about a little mistake in=20
=20
PostgreSQL 7.1 Documentation
Chapter 3. Data Types
3.8. Bit String Types

Bit strings are strings of 1's and 0's. They can be used to store or
visualize bit masks. There are two SQL bit types: BIT(x) and BIT
VARYING(x); the x specifies the maximum
length. BIT type data is automatically padded with 0's on the right to
the maximum length, BIT VARYING is of variable length. BIT without
length is equivalent to BIT(1), BIT
VARYING means unlimited length. Input data that is longer than the
allowed length will be truncated. Refer to Section 1.1.2.2 for
information about the syntax of bit string
constants. Bit-logical operators and string manipulation functions are
available; see Chapter 4.=20

Some examples:=20

CREATE TABLE test (a BIT(3), b BIT VARYING(5));
INSERT INTO test VALUES (B'101', B'00');        ### try: ..VALUES
(B'101', 'B00') instead of: ..VALUES (B'101', B'00')=20=20
SELECT SUBSTRING(b FROM 1 FOR 2) FROM test;


Thats it for the moment and
Thanks For That Great Database

Ralf

--=20
**************************************************************************

Wir w=FCrden uns freuen, Sie in der Zeit vom 22.03. - 28.03. auf der CeBIT
2001 in Hannover begr=FC=DFen zu d=FCrfen. Halle 25 Stand 36A.

**************************************************************************

Dipl.-Ing.(FH) Ralf Miller		topnet-AG
ralf.miller@topnet.de			Willstaetterstrasse 13
Telefon 0211 53087-244			40549 D=FCsseldorf
Fax	0211 53087-199			http://www.topnet.de
--------------CD590358D1FF5B498A0C3C06
Content-Type: text/x-vcard; charset=us-ascii; name="ralf.miller.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Karte für Ralf Miller
Content-Disposition: attachment; filename="ralf.miller.vcf"

begin:vcard 
n:Miller;Ralf
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:ralf.miller@topnet.de
note:Telefon 0211-53087-244
x-mozilla-cpt:;0
fn:Ralf Miller
end:vcard

--------------CD590358D1FF5B498A0C3C06--