From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
cc: Dean Rasheed <dean.a.rasheed@gmail.com>,
        John Naylor <john.naylor@enterprisedb.com>,
        Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
        pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Non-decimal integer literals
In-reply-to: 
 <CAApHDvqOe9Oip=j2UB8FZCKrPLrrY4OHDe96qNWnaYQeb5mgwg@mail.gmail.com>
References: <b239564c-cad0-b23e-c57e-166d883cb97d@enterprisedb.com>
 <CAFBsxsEt_CFGk1vBEn=arrDKMFfdryjDHnNvFzpkhh+MktGNKA@mail.gmail.com>
 <0f37d2ec-6689-4d23-7ba5-4d2a73c2666f@enterprisedb.com>
 <577603ec-787b-61b8-23a2-1bd0457ed1c7@enterprisedb.com>
 <be7fb835-abf9-2f5a-de5d-ad946a7d42e1@enterprisedb.com>
 <c42cb38a-ac42-dd92-2935-dce3b9806e26@enterprisedb.com>
 <CA+TgmoZv2Q11P1JbF+ziu1b8vsBpcjfPqXsHMR0hJqSTeLP1xQ@mail.gmail.com>
 <bef9c869-e773-f792-fde2-d7555add2879@enterprisedb.com>
 <CA+TgmoZRJzBe6yKeBpQ2auHndeV-bzygSY=gr0A0KixZ2giKNg@mail.gmail.com>
 <2317133.1643155358@sss.pgh.pa.us>
 <97aa22d7-b80f-efa1-f368-3dbf73a15980@enterprisedb.com>
 <CAFBsxsGcgqJ_KO-1=jCUJKK2z5rCh2qsf7=VgNWzTvakLMDyBQ@mail.gmail.com>
 <bc462aff-675b-86e2-46e3-7eaf5ce3e75f@enterprisedb.com>
 <071c40f2-15cf-5db3-8799-dbac041bb881@enterprisedb.com>
 <CAFBsxsG4m9qK=vyLAj2DGo3vZ6AC0vRxA4gWtExH5RGP=sPo_Q@mail.gmail.com>
 <b70b15fc-7f8d-5370-21fc-4ec3c154aef3@enterprisedb.com>
 <791aee01-f488-0706-2694-08c5b57a3bdd!
 @enterprisedb.com>
 <CAApHDvr6m8Sipff_MjqyQ8HLeDA3LB5x9zE1oMBPBLxFwTUKQw@mail.gmail.com>
 <CAFBsxsGy0TKkABsKonFgwSsgFP6JnzZEAeDeauC8vrcZ3WDKmg@mail.gmail.com>
 <CAApHDvrL6_+wKgPqRHr7gH_6xy3hXM6a3QCsZ5ForurjDFfenA@mail.gmail.com>
 <CAEZATCUONXthTZWzay_m6NE4Q5QH_KRg=fd2WE1wt2LgFn-CYQ@mail.gmail.com>
 <CAApHDvqOe9Oip=j2UB8FZCKrPLrrY4OHDe96qNWnaYQeb5mgwg@mail.gmail.com>
Comments: In-reply-to David Rowley <dgrowleyml@gmail.com>
	message dated "Thu, 01 Dec 2022 12:11:56 +1300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1467946.1669851407.1@sss.pgh.pa.us>
Date: Wed, 30 Nov 2022 18:36:47 -0500
Message-ID: <1467947.1669851407@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1467947.1669851407%40sss.pgh.pa.us>
Precedence: bulk

David Rowley <dgrowleyml@gmail.com> writes:
> I agree that it should be a separate patch.  But thinking about what
> Tom mentioned in [1], I had in mind this patch would need to wait
> until the new standard is out so that we have a more genuine reason
> for breaking existing queries.

Well, we already broke them in v15: that example now gives

regression=# select 0x42e;
ERROR:  trailing junk after numeric literal at or near "0x"
LINE 1: select 0x42e;
               ^

So there's probably no compatibility reason not to drop the
other shoe.

			regards, tom lane