[sf-perl] Perl's to_date() equivalent
Josh Berkus
josh at agliodbs.com
Fri Sep 1 15:29:02 PDT 2006
Peter,
> Netezza does support to_date(), but the problem is I need to compare
> current row's date to the previous rows date. I suppose I could do:
Previous by date? That's a SQL problem, not a Perl problem. Albeit an
really annoying one with a large database. Can you give us the schema of
the table?
Too bad Netezza doesn't support custom running aggregates. You could do
this easily in mainstream PostgresQL (using PL/perl no less).
--
--Josh
Josh Berkus
PostgreSQL @ Sun
San Francisco
More information about the SanFrancisco-pm
mailing list