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

From Tom Lane
Subject Re: Ought binary literals to allow spaces?
Date
Msg-id 6695.1582495250@sss.pgh.pa.us
Whole thread Raw
In response to Ought binary literals to allow spaces?  (Chapman Flack <chap@anastigmatix.net>)
List pgsql-hackers
Chapman Flack <chap@anastigmatix.net> writes:
> 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.

Hmm.  SQL99 did not allow noise spaces in <binary string literal> and
related productions, but it does look like they added that in SQL:2008.

> (The B'...' form appears to be a PostgreSQL extension, but I imagine
> if ISO had it, it would allow spaces too.)

The B'...' form was there in SQL99.  The committee took it out in
SQL:2003 or so, along with the BIT type, but we still have both.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Add kqueue(2) support to the WaitEventSet API.
Next
From: Justin Pryzby
Date:
Subject: v12 "won't fix" item regarding memory leak in "ATTACH PARTITIONwithout AEL"; (or, relcache ref counting)