Re: Comparar Dos TIMESTAMP

>
>
> Raro. ¿Que retorna lo siguiente?
>
> select fecha, age(fecha::timestamp), age(fecha::timestamptz) from
> consulta;

Si de algo Sirve:

CREATE TABLE consulta
(
id_caso varchar(10) NOT NULL,
fecha timestamp NOT NULL,
id_med text NOT NULL,
comentario text,
CONSTRAINT consulta_pkey PRIMARY KEY (id_caso, fecha),
CONSTRAINT consulta_id_caso_fkey FOREIGN KEY (id_caso)
REFERENCES caso (id_caso) MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT consulta_id_med_fkey FOREIGN KEY (id_med)
REFERENCES medico (id_med) MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE
)
WITHOUT OIDS;
ALTER TABLE consulta OWNER TO postgres;