Re: bit-strings with white space

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: bit-strings with white space
Дата
Msg-id 26418.1524417492@sss.pgh.pa.us
обсуждение исходный текст
Ответ на bit-strings with white space  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: bit-strings with white space  (Jim Nasby <jim@nasby.net>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: authentication methods sections
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: bit-strings with white space