Postgres Pro
Downloads
Home   >   mailing lists

Re: Hex numbers in psql - Mailing list pgsql-general

From Kris Jurka
Subject Re: Hex numbers in psql
Date
Msg-id Pine.BSO.4.64.0705201251530.30824@leary.csoft.net
Whole thread Raw
In response to Hex numbers in psql  ("madhtr" <madhtr@schif.org>)
List pgsql-general
Tree view 

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

pgsql-general by date:

Previous
From: "Henka"
Date:
Subject: Re: Transaction commit in a trigger function
Next
From: Tom Lane
Date:
Subject: Re: exception question ....