Re: bit-strings with white space

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pauleg(dot)carter(at)gmail(dot)com
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: bit-strings with white space
Date: 2018-04-22 17:18:12
Message-ID: 26418.1524417492@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

=?utf-8?q?PG_Doc_comments_form?= <noreply(at)postgresql(dot)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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Jim Nasby 2018-04-23 03:50:50 Re: bit-strings with white space
Previous Message Peter Eisentraut 2018-04-21 14:21:03 Re: authentication methods sections