Re: constraints evaluate 'now' immediately - Mailing list pgsql-bugs

pgsql-bugs@postgresql.org writes:
> I would like a constraint stating that a column may not have a date in the future:
> CHECK(my_date <= 'now')
> but I think it stores the time of constraint creation.

Yes, because 'now' is evaluated when the constant is parsed.  Try
    CHECK(my_date <= now())
instead.

            regards, tom lane