It seems like it would be worth noting these (and any others) in the
docs in some way. Is there a way for someone without a copy of the spec
to be aware of which are functions and which are not, otherwise?
-tfo
On Sep 29, 2004, at 9:25 AM, Kris Jurka wrote:
On Wed, 29 Sep 2004, Thomas F.O'Connell wrote:
Note: EXTRACT is not a true function. SQL defines it as an expression
that happens to look similar to a function call.
Also, are there other expressions that fall into this category? I
don't
know the spec well enough to know.
At least COALESCE and NULLIF are not functions.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
