From: | Francisco Reyes <lists(at)natserv(dot)com> |
---|---|
To: | pgsql General List <pgsql-general(at)postgresql(dot)org> |
Subject: | bytea to int conversion? |
Date: | 2002-07-09 02:44:37 |
Message-ID: | 20020708223910.A42709-100000@zoraida.natserv.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Is there a way to convert bytea to int?
I just got the libcrypto library installed in order to get CRC32 support.
After getting some help I got it working, but now I am trying to figure
out how to compare the value returned by the function, bytea, with PHP's
CRC32 (a number).
I did not see any function to do such conversion.
I also wonder what are some letters that appear to the left or right of
the backlashed numbers.
From reading the documentation it seems bytea are numbers on base 8.
For example I tried select digest('a','crc32');
digest
---------------
k\233\223\031
(1 row)
I converted the 233, 223 and 031 to hex
9b 93 19
and then to decimal
10195737
But this differs from the result from PHP's CRC32 computation for the
same, 'ab', string -1635563411
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2002-07-09 02:47:46 | Re: I am being interviewed by OReilly |
Previous Message | Bruce Momjian | 2002-07-09 02:32:43 | Re: [INTERFACES] pgaccess problems |