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

From Tom Lane
Subject Re: bit-strings with white space
Date
Msg-id 26418.1524417492@sss.pgh.pa.us
Whole thread Raw
In response to bit-strings with white space  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: bit-strings with white space
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


pgsql-docs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: authentication methods sections
Next
From: Jim Nasby
Date:
Subject: Re: bit-strings with white space