pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedslight mistake in documentation
3+ messages / 3 participants
[nested] [flat]
* slight mistake in documentation
@ 2001-03-21 17:36 Ralf Miller <ralf.miller@topnet.de>
0 siblings, 2 replies; 3+ messages in thread
From: Ralf Miller @ 2001-03-21 17:36 UTC (permalink / raw)
To: pgsql-docs
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
Attachments:
ralf.miller.vcf (text/x-vcard, 177B) download
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
* Re: slight mistake in documentation
@ 2001-03-21 20:27 Peter Eisentraut <peter_e@gmx.net>
parent: Ralf Miller <ralf.miller@topnet.de>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2001-03-21 20:27 UTC (permalink / raw)
To: Ralf Miller <ralf.miller@topnet.de>; +Cc: pgsql-docs
Ralf Miller writes:
> 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;
Why?
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: slight mistake in documentation
@ 2001-05-04 22:20 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Ralf Miller <ralf.miller@topnet.de>
1 sibling, 0 replies; 3+ messages in thread
From: Bruce Momjian @ 2001-05-04 22:20 UTC (permalink / raw)
To: Ralf Miller <ralf.miller@topnet.de>; +Cc: pgsql-docs
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-05-04 22:20 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-21 17:36 slight mistake in documentation Ralf Miller <ralf.miller@topnet.de>
2001-03-21 20:27 ` Peter Eisentraut <peter_e@gmx.net>
2001-05-04 22:20 ` Bruce Momjian <pgman@candle.pha.pa.us>
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