[sf-perl] Perl's to_date() equivalent

Josh Berkus josh at agliodbs.com
Fri Sep 1 15:29:02 PDT 2006


> 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 Berkus
PostgreSQL @ Sun
San Francisco

More information about the SanFrancisco-pm mailing list