Re: Converting BYTEA from/to BIGINT

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?

Something like:

CREATE OR REPLACE FUNCTION bytea_to_int8( ba BYTEA, OUT res INT8 )
LANGUAGE plpgsql STRICT
AS $BODY$
DECLARE
  i INT;
BEGIN
  res := 0;
  FOR i IN 0 .. 7 LOOP
    res := 256*res + get_byte( ba,i );
  END LOOP;
END;
$BODY$;

gives me back errors (ERROR:  bigint out of range) because of overflow
at step no.7

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