Re: Functions and Parentheses

"Igal @ Lucee.org" <igal@xxxxxxxxx> · Fri, 6 Oct 2017 16:10:03 -0700



    On 10/6/2017 3:10 PM, Joshua D. Drake wrote:

    On
      10/06/2017 02:33 PM, Tom Lane wrote:
      

      "Igal @ Lucee.org" <igal@xxxxxxxxx>
        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.
      

    +1

    
    I also want to say that I'm using many different open source
    projects, but Postgres has by far the best community support of all,
    not to mention a product that is far superior to the many commercial
    alternatives in the market.

    
    It's kind of like -- I can use Postgres for free, or I can spend a
    lot of money and get an inferior product with inferior support.

    
    If Postgres had been written in Java then I'd be much more involved,
    but my C/C++ skills are rather limited.

    
    Anyway, great job guys!  And Thank you!

    
      Igal Sapir
        

        Lucee Core Developer
        

        Lucee.org