Re: bit-strings with white space - Mailing list pgsql-docs

=?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