Panos Kassianidis wrote:
Thanks very much for the answer. Could you also please tell me how am I supposed to write such a function? How is date_trunc implemented so that I can extend it? In C in SQL?
I'd probably write it in plpgsql unless you need the speed.
And where can I find its source code?
With the source - available from the website. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend