Re: Converting BYTEA from/to BIGINT

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Converting BYTEA from/to BIGINT
Date: 2010-07-26 10:04:26
Message-ID: AANLkTinoNO77XnMzyVAqxpEJjwY=vF4ty6_=QF5aa+tj@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/7/26 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
> Hello
>
> you can try
>
> postgres=# select int8send(256);
>      int8send
> --------------------
>  \x0000000000000100
> (1 row)
>
> for converting from bytea to int8 you need a custom function - probably in C :(

int8send?

--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Artur Dabrowski 2010-07-26 10:20:16 Re: Incorrect FTS result with GIN index
Previous Message Vincenzo Romano 2010-07-26 10:03:45 Re: Converting BYTEA from/to BIGINT