now() literal in pg_input_is_valid

Started by jian healmost 3 years ago2 messagesgeneral
Jump to latest
#1jian he
jian.universality@gmail.com

Hi
should I expect
select pg_input_is_valid($$[now(), infinity)$$,'tstzrange');
returns true?

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: jian he (#1)
Re: now() literal in pg_input_is_valid

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