Date: Fri, 5 Jul 2024 16:55:42 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: David Rowley <dgrowleyml@gmail.com>,
	"David G. Johnston" <david.g.johnston@gmail.com>,
	Peter Eisentraut <peter@eisentraut.org>,
	James Coleman <jtc331@gmail.com>,
	pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Should we document how column DEFAULT expressions work?
Message-ID: <ZohdzuEQ-oaAuUgs@momjian.us>
References: <1642803.1719447063@sss.pgh.pa.us>
 <CAApHDvouPRyga3-5ZYLt_RUhU942bk0WPVgro+U=R3cvBRXbeQ@mail.gmail.com>
 <ef4d9b38-b7a5-4c85-ba12-062929c2d136@eisentraut.org>
 <CAApHDvrURTcDn3GTsmXzm9VqT3acLh=T=aUYMuKrtozw0nq8Tg@mail.gmail.com>
 <CAKFQuwbOOQ20=Pb5j-k+Sws22H5W9tnj-vve4MC-GQ9RmmtTxA@mail.gmail.com>
 <CAApHDvogKE8RrHx=qmYfvpD_AiVLX14nLvvSrPbFCXWgiYrKxg@mail.gmail.com>
 <CAKFQuwZjuQX4H48MbaHZAX3s__LoHgkXsf2Eg--E=qtWFss0bg@mail.gmail.com>
 <CAApHDvrQ--Mzp00Yn=3SVB=YS_ZB15aeLywaK0n05-adk8WWmw@mail.gmail.com>
 <ZohYEScvGh3gn136@momjian.us>
 <342046.1720212632@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <342046.1720212632@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/ZohdzuEQ-oaAuUgs%40momjian.us>
Precedence: bulk

On Fri, Jul  5, 2024 at 04:50:32PM -0400, Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Also interestingly, "now" without quotes requires parentheses to make it
> > a function call:
> 
> I'm not sure why you find that surprising, or why you think that
> 'now()'::timestamptz is a function call.  (Well, it is a call of
> timestamptz_in, but not of the SQL function now().)  Documentation
> that is equally confused won't help any.

Well, 'now()' certainly _looks_ like a function call, though it isn't. 
The fact that 'now()'::timestamptz and 'now'::timestamptz generate
volatile results via a function call was my point.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.