pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
now() literal in pg_input_is_valid
2+ messages / 2 participants
[nested] [flat]

* now() literal in pg_input_is_valid
@ 2023-07-09 12:13  jian he <jian.universality@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: jian he @ 2023-07-09 12:13 UTC (permalink / raw)
  To: pgsql-general list <pgsql-general@lists.postgresql.org>

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: now() literal in pg_input_is_valid
@ 2023-07-09 14:22  Tom Lane <tgl@sss.pgh.pa.us>
  parent: jian he <jian.universality@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2023-07-09 14:22 UTC (permalink / raw)
  To: jian he <jian.universality@gmail.com>; +Cc: pgsql-general list <pgsql-general@lists.postgresql.org>

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2023-07-09 14:22 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-07-09 12:13 now() literal in pg_input_is_valid jian he <jian.universality@gmail.com>
2023-07-09 14:22 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox