Hi Paolo, Why is postgresql set to having the timestamps set to "timestamp without time zone"?
I am having issues doing some queries and wonder what might be a nfacctd problem if I move the table to use timestamp WITH time zone. as an aside: here is an SQL issue I'm having problems with.. pmacct=> SELECT step.date,CAST(step.date as int),foo.mb FROM (SELECT acct_v6.stamp_inserted,SUM(acct_v6.bytes) AS mb FROM acct_v6 WHERE as_src = '714' GROUP BY stamp_inserted) AS foo RIGHT OUTER JOIN (select '2009-10-26'::timestamp + i*'10 minute'::interval AS date FROM generate_series(0,144) AS i) AS step ON (step.date=foo.stamp_inserted) ; ERROR: cannot cast type timestamp without time zone to integer LINE 1: SELECT step.date,CAST(step.date as int),foo.mb FROM ^ pmacct=> (ie. I am trying to pull out each acct_v6.stamp_inserted and JOIN it with a generated interval as i have set in $sql_history so I can gnuplot a time-series) Let me know if I can scrap this with something easier :) Regards, C. -- Media Service Provider Ltd. http://blog.playlouder.com/ http://as47998.net/ 020 7729 4797 _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists