Re: Dates rejected - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Dates rejected
Date
Msg-id 20061016154037.GA13156@KanotixBox
Whole thread Raw
In response to Re: Dates rejected  (Martijn van Oosterhout <kleptog@svana.org>)
Responses RES: Dates rejected  ("Carlos H. Reimer" <carlos.reimer@opendb.com.br>)
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> schrieb:
> > create table tt_teste (datfis timestamp without time zone not null
> >  CHECK (datfis = trunc(datfis::timestamp without time zone)));
>
> What are you trying to do here? If you only want a date, why not just
> use a date type?

This is an other question ;-)


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Dates rejected
Next
From: Adrian Suciu
Date:
Subject: Real time query analyzer