Am Freitag, 6. Juli 2007 11:15 schrieb Stefan Christ: > the documentation of PGSQL 8.0 tells me, that extract(dow ...) will > return 0 for Sundays. I know that this behaviour depends on the > language settings on MSSQL, so that I have to correct this settings > with an offset. What is the behaviour in PGSQL? Does the dow result > also depend on the language settings, or will the value 0 ALWAYS be a > Sunday?
It's always that way for this particular function. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(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