From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200105042220.f44MKN322199@candle.pha.pa.us>
Subject: Re: slight mistake in documentation
In-Reply-To: <3AB8E69C.E2783619@topnet.de> "from Ralf Miller at Mar 21, 2001
	06:36:28 pm"
To: Ralf Miller <ralf.miller@topnet.de>
Date: Fri, 4 May 2001 18:20:23 -0400 (EDT)
CC: pgsql-docs@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=UNKNOWN-8BIT


I am confused what change you are suggesting here.

[ Charset ISO-8859-1 unsupported, converting... ]
> Hello,
> 
> i shortly like to give You a hint about a little mistake in 
>  
> 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. 
> 
> Some examples: 
> 
> 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')  
> SELECT SUBSTRING(b FROM 1 FOR 2) FROM test;
> 
> 
> 
> Thats it for the moment and
> Thanks For That Great Database
> 
> Ralf
> 
> -- 
> **************************************************************************
> 
> Wir w?rden uns freuen, Sie in der Zeit vom 22.03. - 28.03. auf der CeBIT
> 2001 in Hannover begr??en zu d?rfen. Halle 25 Stand 36A.
> 
> **************************************************************************
> 
> Dipl.-Ing.(FH) Ralf Miller		topnet-AG
> ralf.miller@topnet.de			Willstaetterstrasse 13
> Telefon 0211 53087-244			40549 D?sseldorf
> Fax	0211 53087-199			http://www.topnet.de

Content-Description: Karte für Ralf Miller

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026