Lo.
I'm in dire need of knowledge, how to extract data by month. Monthday
and year arent' important, those I can't give from perl script, but what
I do give to postgres are the numbers of the months. Date field is in
timestamp. I thought about date_trunc, but I can't think of, how to get
data with it. In script will be 12 queries, for each month, to get the
news from that month.
Btw, is there somewhere a manual about date_trunc, the docs that come with
RH6.1 distribution are somewhat short and lacking explanation of
date_trunc.
Antti