On Tue, 2006-12-19 at 23:39 +0100, Magnus Hagander wrote: > Peter Eisentraut wrote: > > Magnus Hagander wrote: > >> In most cases, I just assume they would just assume > >> they can't use units on it because the default value in the file > >> doesn't have units. > > > > But the default value *does* have units. > > > It does? Didn't in my file. I must've overwritten it with a config file > from some earlier beta (or snapshot) that didn't have it or so - my > default value certainly didn't have it ;-)
Just to confirm, yes the sample I submitted a patch for does have units. Joshua D. Drake > > //Magnus > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate ---------------------------(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