Robson-
two suggestions-
This is an SQL question, so it should be posted to the pgsql-sql list, not
the admin list. You can get information about subscribing to the pgsql-sql
list here:
http://www.postgresql.org/idocs/index.php?sql-expressions.html
To find information on your own, the idocs are a great resource. You can
find them here:
http://www.postgresql.org/idocs/
Searching on "cast" from the idocs page led me to this page, which will show
you how to do the explicit cast required to make the expression you sent at
least syntactically correct:
http://www.postgresql.org/idocs/index.php?sql-expressions.html
Regards,
-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: Friday, June 14, 2002 9:39 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Divide Date with interger
As to divide one i number int number with date
Exemplo:
> Select Max(RazaoSocial) As mRazaoSocial, Max(Endereco) As mEndereco,
Max(Bairro) As mBairro, Max(Cidade) As mCidade, Max(CEP) As mCEP, Max(UF) As
mUF, ('(' || Max(DDD) || ') ' || Max(Fone1)) As mFone, Max(Data) As mData,
Sum(Qtde) As mQtde, DescCor As mCor FROM Movimento, Clientes, Cores WHERE
Movimento.CGC = Clientes.CGCCli And Clientes.TipoCli = 'N' And
Clientes.CodCli > 1 And (Clientes.Class = 'A' Or Clientes.Class = 'B' Or
Clientes.Class = 'C') And Movimento.CodCor = Cores.CodCor And Movimento.Data
>=(current_date-(30*4)) And Movimento.CodProduto = '2491' And Clientes.UF =
'SP' Group By CGCCli, DescCor Order By (Sum(Qtde) / (current_date +
1 -Max(Data))) Desc
Error: ERROR: Unable to identify an operator '/' for types 'numeric' and
'interval'
You will have to retype this query using an explicit cast
Regards.
