re : Casting macaddr types to text - Mailing list pgsql-general

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