Roy Badami wrote: > Bruce> select interval day to second '1 day 1 hour' > > Bruce> However, we don't support that syntax, only the one with > Bruce> the specification after. > > Is that valid ANSI SQL?
No idea. It just seemed like the data type specification and the data value specification has to be split apart somehow. Right now we use the clause after the string as the date type specification, and I see you saying that the data value specification has to after the string. Is that correct? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
