Skip site navigation (1) Skip section navigation (2)

Re: hexdecimal constant in postgresql

From: Chris <list(at)1006(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: hexdecimal constant in postgresql
Date: 2004-07-27 07:29:32
Message-ID: 1090913372.5322.1.camel@dell (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
> i was wondering how to specify hexadecimal constants in
> SQL in a way that postgresql understands.
> something like:
> select 0xFFFF;   -- this doesn't work;
> I've googled for it and i've found it can be done with
> encode/decode involving a bytea type - but i'm under
> the impression there must be a more straightforward way...

I've found it myself :)

  select x'FFFF'::int;     -- this works

Bye, Chris.

In response to

pgsql-novice by date

Next:From: Rafael CharnovsckiDate: 2004-07-27 13:33:45
Subject: Re: Varchar or integer primary key?
Previous:From: Stephan SzaboDate: 2004-07-27 04:49:58
Subject: Re: help with conversion functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group