I was looking for a way to cast hex numbers (stored in a varchar column)
to int. I found many people asking the same thing, but no answers.
It seems that this is supported by the following syntax
Since this doesn't work with variable values, I wrote this following
function. Perhaps it will help anyone wanting to do the same thing.
CREATE OR REPLACE FUNCTION hex_to_int(varchar) RETURNS integer AS '
h alias for $1;
exec := ''SELECT x'''''' || h || ''''''::int'';
OPEN curs FOR EXECUTE exec;
FETCH curs INTO res;
Richard van den Berg, CISSP
Trust Factory B.V. | http://www.trust-factory.com/
Bazarstraat 44a | Phone: +31 70 3620684
NL-2518AK The Hague | Fax : +31 70 3603009
The Netherlands |
pgsql-general by date
|Next:||From: Janez Kostanjšek||Date: 2004-05-26 14:17:17|
|Subject: Error: server closed the connection unexpectedely|
|Previous:||From: Robert Treat||Date: 2004-05-26 13:51:41|
|Subject: Re: Clustering Postgres|