On Mon, Jan 24, 2005 at 02:28:48PM -0500, Merlin Moncure wrote: > I have to ask this...why is 'allballs' accepted as a literal for time?
"Allballs" is slang for "all zeros" because zeros look like balls. You hear it sometimes in environments that use a 24-hour clock (communications, military, etc.). Here's an example: http://www2.jpl.nasa.gov/basics/bsf2-3.html I don't know that "allballs" is specified in any standard, so I suspect that somebody who used the term added it to PostgreSQL (or whatever it was called at the time) for convenience. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(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
