Roy Badami wrote: > > Bruce> * Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 > Bruce> minute 30 seconds' > > This seems redundant; it's just another example of the ANSI day-time > interval syntax...
The reason I added it is that usually people think of the PG syntax as '1 hour 30 seconds'. The '1:30' is a kind of subtle because both PG and ANSI support that syntax and we need to handle that. The tricky part is that we can't say by looking at '1:30' whether it is PG or ANSI, and that will affect how we deal with the clause after it. -- 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 8: explain analyze is your friend
