Re: [GENERAL] Functions and Parentheses - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: [GENERAL] Functions and Parentheses
Date
Msg-id 34d1f1b0-2455-6014-2343-ff1623edd590@commandprompt.com
Whole thread Raw
In response to Re: [GENERAL] Functions and Parentheses  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] Functions and Parentheses
List pgsql-general
On 10/06/2017 02:33 PM, Tom Lane wrote:
> "Igal @ Lucee.org" <igal@lucee.org> writes:
>> How come `current_date` has no parenthesis but `clock_timestamp()` does?
> 
> Because the SQL standard says that CURRENT_DATE doesn't have parentheses.
> It is a function by any other measure, though.
> 
> (AFAICT, the SQL committee is unacquainted with any principles of
> programming language syntax design that emerged later than the COBOL
> era.  Their capacity to invent new and non-orthogonal syntax for every
> new feature seems boundless.)

This is the best statement I have read all week.

JD


> 
>             regards, tom lane
> 
> 


-- 
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc

PostgreSQL Centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://pgconf.us
*****     Unless otherwise stated, opinions are my own.   *****


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Functions and Parentheses
Next
From: "Igal @ Lucee.org"
Date:
Subject: Re: [GENERAL] Functions and Parentheses