Re: Converting BYTEA from/to BIGINT - Mailing list pgsql-general

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 :(

Pavel


2010/7/26 Vincenzo Romano <vincenzo.romano@notorand.it>:
> Hi all.
>
> I'd like to convert an 8-bytes BYTEA into a BIGINT and possibly vice versa.
> Is there any way to do it?
>
> --
> Vincenzo Romano
> NotOrAnd Information Technologies
> NON QVIETIS MARIBVS NAVTA PERITVS
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>