[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