Postgres Pro
Downloads
Home   >   mailing lists

Re: Allowing postgresql to accept 0xff syntax for data types that it makes sense for? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Allowing postgresql to accept 0xff syntax for data types that it makes sense for?
Date
Msg-id mjpood$p5u$1@ger.gmane.org
Whole thread Raw
In response to Re: Allowing postgresql to accept 0xff syntax for data types that it makes sense for?  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general
Tree view 
Bill Moran wrote on 22.05.2015 18:57:
> Arrgh ... it's good that you're bringing this up, but you're making me
> realize that there's more to figure out than I originally thought ...
> My focus had been on it being used for BYTEA columns, but there _are_
> plenty of places in the code that do things like:

If this is only about a more compact format for BYTEA, the following is valid in Postgres:

   select '\xff'::bytea

It's not exactly what you are after, but maybe "good enough".

pgsql-general by date:

Previous
From: twoflower
Date:
Subject: Server tries to read a different config file than it is supposed to
Next
From: Thomas Kellerer
Date:
Subject: Re: Allowing postgresql to accept 0xff syntax for data types that it makes sense for?