Ought binary literals to allow spaces? - Mailing list pgsql-hackers

From Chapman Flack
Subject Ought binary literals to allow spaces?
Date
Msg-id 5E52B530.5040900@anastigmatix.net
Whole thread Raw
Responses Re: Ought binary literals to allow spaces?
List pgsql-hackers
Hi,

ISO seems to allow spaces among the digits of a binary literal, so as
to group them for readability, as in X'00ba b10c'. We seem not to.
(The B'...' form appears to be a PostgreSQL extension, but I imagine
if ISO had it, it would allow spaces too.)

Is it worthwhile to allow that? Or to add a compatibility note somewhere
around sql-syntax-bit-strings saying we don't allow it?

For comparison, byteain does allow grouping whitespace.

It seems that byteain allows arbitrary whitespace (tabs, newlines, etc.),
whereas ISO's X'...' allows exactly and only U+0020 space characters.

Whitespace for byteain must occur between digit pairs; spaces in X'...'
per ISO can be anywhere.

Regards,
-Chap



pgsql-hackers by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: Re: Error on failed COMMIT
Next
From: Thomas Munro
Date:
Subject: Re: Yet another fast GiST build