Reason why set-value functions not allowed in GREATEST(), etc?

From: Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Reason why set-value functions not allowed in GREATEST(), etc?
Date: 2010-02-22 17:25:11
Message-ID: e08cc0401002220925t3d93001cq429e00e8fcaf58b8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I just wonder why generate_series() is not allowed in GREATEST syntax.
Looking through execQual.c, almost all syntactic evaluations like
COALESCE, ARRAY[], ROW() doesn't allow set-value functions. Could
someone tell the underlying reason?

Also, using variadic functions introduced since 8.4, I hope we can
remove the special syntax cases for them by replacing them with normal
variadic functions. Is it sane idea?

Regards,

--
Hitoshi Harada

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris Campbell 2010-02-22 17:31:17 Re: Recent vendor SSL renegotiation patches break PostgreSQL
Previous Message Tom Lane 2010-02-22 17:25:08 Re: Recent vendor SSL renegotiation patches break PostgreSQL