Re: Filtering data based on timestamp

From: Richard Huxton <dev(at)archonet(dot)com>
To: Panos Kassianidis <pkas(at)inaccessnetworks(dot)com>, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Filtering data based on timestamp
Date: 2006-02-07 17:03:07
Message-ID: 43E8D2CB.2050105@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2006-02-07 17:45:53 Re: trecherous subselect needs warning?
Previous Message george young 2006-02-07 17:01:10 trecherous subselect needs warning?