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) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend