re : Casting macaddr types to text

Hi,

Try this function ( with psql ) and redo your query.
This function allow cast beetween macaddr and text

CREATE FUNCTION text(macaddr) returns text AS '
BEGIN
return $1;
END;
' LANGUAGE 'plpgsql';

Cheers,

PEJAC Pascal