On Tue, 2008-01-29 at 13:20 -0500, Tom Lane wrote: > The reason it was kept was to override the search path --- unqualified > NUMERIC will always be taken as pg_catalog.numeric even if you have some > other type "numeric" in front of it.
It should be possible to implement this behavior without requiring NUMERIC to be a keyword, though. -Neil ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match