A Database Error Occurred

Error Number:

ERROR: function x(geometry) does not exist LINE 1: ...date as inc_f, eventos.*, cat.nombre as categoria,X(the_geom... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

select fecha_i-current_date as inc_i, fecha_f-current_date as inc_f, eventos.*, cat.nombre as categoria,X(the_geom) as x, Y(the_geom) as y from eventos, eventos_categorias cat where ciu=1 and eventos.idcategoria=cat.id and current_date >= fecha_i and current_date <= fecha_f and activo=1 order by cat.id