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 [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Robson Martins Sent: Friday, June 14, 2002 9:39 AM To: [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
