Robson-
In this, and your last question, the problem is that you are using functions
from Microsoft Access. You'll keep running into this until you learn about
the equivalent functions in PostgreSQL.
The PostgreSQL functions are explained here:
http://www.postgresql.org/idocs/index.php?functions.html
You may also want to learn how to create your own functions in case there is
no equivalent:
http://www.postgresql.org/idocs/index.php?sql-createfunction.html
-Nick
--------------------------------------------------------------------------
Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Robson Martins
Sent: Thursday, June 13, 2002 2:30 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Err sum number with Date ?
What err ?
Order By (Sum(Qtde)/(1+current_date-Max(Data))) Desc
Regards,
Robson