Re: SELECT of pseudo hex value gives unexpected result

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "Gunnar \"Nick\" Bluth" <gunnar(dot)bluth(at)pro-open(dot)de>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: SELECT of pseudo hex value gives unexpected result
Date: 2019-01-29 16:41:21
Message-ID: 20ce81e922adf485fe745f40b1da596de53a4c08.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gunnar "Nick" Bluth wrote:
> Tried
> SELECT 0x5e73266725;
>
> and received:
> -[ RECORD 1 ]--
> x5e73266725 | 0
>
> That was not what I expected... is this expected/documented behaviour?

Looks like you don't need a space between a number literal and
the column alias.

I don't see any problem with that.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gunnar "Nick" Bluth 2019-01-29 16:55:29 Re: SELECT of pseudo hex value gives unexpected result
Previous Message Tom Lane 2019-01-29 16:39:29 Re: SELECT of pseudo hex value gives unexpected result