Hash problem

Hi all,

I am back to trying to get the forum software called 'Ikonboard'
working under postgres (it's advertised as being supported but the
developers confirmed their pgSQL person left a while back).

At the moment I am (well, the program is) getting trying to perform
this query:

SELECT * FROM tf_forum_posts WHERE FORUM_ID = HASH(0x868d4e0) AND
TOPIC_ID = AND QUEUED = '0' ORDER BY POST_DATE LIMIT 2;

which throws this error:

ERROR: parser: parse error at or near "x868d4e0" at character 53

Most of the problems so far have stemmed from changes from (I think)
pgSQL 7.2 (the last version the program was actively tested on) to 7.4.
I have yet to test it under 8.0. Does this seem like an obvious syntax
error in the newer versions of pgSQL? If so, what is a valid substitution.

Thanks a lot! (I'm not -quite- a n00b but I am still learning. :) )

Madison

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Madison Kelly (Digimer)
TLE-BU, The Linux Experience; Back Up
http://tle-bu.thelinuxexperience.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-