Postgres Pro
Downloads
Home   >   mailing lists

Re: now() literal in pg_input_is_valid - Mailing list pgsql-general

From Tom Lane
Subject Re: now() literal in pg_input_is_valid
Date
Msg-id 1867891.1688912522@sss.pgh.pa.us
Whole thread Raw
In response to now() literal in pg_input_is_valid  (jian he <jian.universality@gmail.com>)
List pgsql-general
Tree view 
jian he <jian.universality@gmail.com> writes:
> should I expect
> select  pg_input_is_valid($$[now(), infinity)$$,'tstzrange');
> returns true?

No.  "now()" is not a literal, it's a function call.

            regards, tom lane

pgsql-general by date:

Previous
From: Rita
Date:
Subject: Re: pgbouncer best practices
Next
From: Avi Weinberg
Date:
Subject: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"