From: ""Fernando Papa"" <[EMAIL PROTECTED]>
> AND upper(cont_publicacion.generar_Vainilla) = 'S'
> Filter: ((upper((generar_vainilla)::text) = 'S'::text) AND
(fecha_publicacion = (subplan)))
using a functional index on this field should help
create index idx_generar_vainilla_ci on cont_publicacion (
upper(generar_Vainilla) )
Regards
Gaetano Mendola
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
