From: Tom Lane <tgl@sss.pgh.pa.us>
To: pauleg.carter@gmail.com
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: bit-strings with white space
Date: Sun, 22 Apr 2018 13:18:12 -0400
Message-ID: <26418.1524417492@sss.pgh.pa.us> (raw)
In-Reply-To: <152404531940.19373.17868808849072401262@wrigleys.postgresql.org>
References: <152404531940.19373.17868808849072401262@wrigleys.postgresql.org>
=?utf-8?q?PG_Doc_comments_form?= <noreply@postgresql.org> writes:
> Postgresql 9.6, section 4.1.2.5 says that bit-strings can spill over
> multiple lines, same as regular string constants. I tried SELECTing such and
> found that they may only contain characters '0' and '1'.
As indeed the text says. What the continuation mention is talking
about is this syntax:
regression=# select b'10001'
'00100';
?column?
------------
1000100100
(1 row)
which works like
regression=# select 'foo'
'bar';
?column?
----------
foobar
(1 row)
Perhaps there's something we could change to make this clearer,
but I'm not sure what.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, pauleg.carter@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: bit-strings with white space
In-Reply-To: <26418.1524417492@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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