2010/2/22 Hitoshi Harada <umi.tan...@gmail.com>: > 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?
we cannot do it :( we cannot ensure similar coercion for these functions with variadic functions. Variadic functions use a generic coercion. Regards Pavel Stehule > > Regards, > > -- > Hitoshi Harada > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
