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

Re: Inverse de to_hex ?

From: "Jean-Christophe Arnu" <jcarnu(at)gmail(dot)com>
To: "Stephane Bortzmeyer" <bortzmeyer(at)nic(dot)fr>
Cc: pgsql-fr-generale(at)postgresql(dot)org
Subject: Re: Inverse de to_hex ?
Date: 2007-09-05 13:23:04
Message-ID: 5b3af220709050623h48675beet1550ecd9ed5d4119@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-fr-generale
Comme l'a pointé Jean-Paul c'est en fait
SELECT x'dc7'::integer;
qui gagne le pompon. :)


Le 05/09/07, Stephane Bortzmeyer<bortzmeyer(at)nic(dot)fr> a écrit :
> On Wed, Sep 05, 2007 at 03:05:48PM +0200,
>  Jean-Christophe Arnu <jcarnu(at)gmail(dot)com> wrote
>  a message of 22 lines which said:
>
> > Un simple integer('0x'||ma_variable) doit suffire non?
>
> Je ne trouve pas cette fonction "integer" dans la documentation et
> PostgreSQL n'a pas l'air de la connaitre :
>
> essais=> SELECT integer('0x' || 'DC7');
> ERROR:  syntax error at or near "(" at character 15
> LINE 1: SELECT integer('0x' || 'DC7');
>                       ^
>


-- 
Jean-Christophe Arnu

In response to

pgsql-fr-generale by date

Next:From: Stephane BortzmeyerDate: 2007-09-05 13:47:19
Subject: Re: Inverse de to_hex ?
Previous:From: Stephane BortzmeyerDate: 2007-09-05 13:21:18
Subject: Re: Inverse de to_hex ?

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