Re: Hex numbers in psql

From: Kris Jurka <books(at)ejurka(dot)com>
To: madhtr <madhtr(at)schif(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Hex numbers in psql
Date: 2007-05-20 16:52:49
Message-ID: Pine.BSO.4.64.0705201251530.30824@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 20 May 2007, madhtr wrote:

> How do use hex numbers in psql? I.E.
>
> instead of:
> select 16
> I want to do
> select 0x10
>

See 4.1.2.3: "SELECT x'1FF'::int"

http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS

Kris Jurka

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-20 17:18:59 Re: exception question ....
Previous Message Henka 2007-05-20 16:48:02 Re: Transaction commit in a trigger function