On 2004.03.29 09:40 Bruno Wolff III wrote:
On Mon, Mar 29, 2004 at 14:30:14 +0200, Bruno BAGUETTE <pgsql-ml@baguette.net> wrote: > Hello, > > It may be a stupid question, but I'm looking to set a check clause in order > to be sure that a INTERVAL field is 00:00:00 or higher, but NOT negatives > values. > > How can I set that ?
check (col_name >= '0 day'::interval)
Is there any way to write a constant interval without a cast? It sure seems awkward to always have to cast. (AT least I always seem to have to cast after my little bit of experiementing.)
(BTW, check (col_name >= CAST ('0 days' AS interval))
is more portable.)Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
