Thread: now() literal in pg_input_is_valid

now() literal in pg_input_is_valid

From
jian he
Date:
Hi
should I expect
select  pg_input_is_valid($$[now(), infinity)$$,'tstzrange');
returns true?



Re: now() literal in pg_input_is_valid

From
Tom Lane
Date:
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