Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT of pseudo hex value gives unexpected result - Mailing list pgsql-general

From Laurenz Albe
Subject Re: SELECT of pseudo hex value gives unexpected result
Date
Msg-id 20ce81e922adf485fe745f40b1da596de53a4c08.camel@cybertec.at
Whole thread Raw
In response to SELECT of pseudo hex value gives unexpected result  ("Gunnar \"Nick\" Bluth" <gunnar.bluth@pro-open.de>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: SELECT of pseudo hex value gives unexpected result
Next
From: "Gunnar \"Nick\" Bluth"
Date:
Subject: Re: SELECT of pseudo hex value gives unexpected result