[HACKERS] Reason why set-value functions not allowed in GREATEST(), etc?
in [PgSql]
|
Prev: Plans for 9.1, Grouping Sets, disablingmultiqueries, contrib module for string, plpgpsm, preload dictionaries
Next: transaction_isolation vs.default_transaction_isolation
From: Hitoshi Harada on 22 Feb 2010 12:25 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |