Postgres Pro
Downloads
Home   >   mailing lists

How I can get the real data type result instead of integer data type? - Mailing list pgsql-general

From Wei Wei
Subject How I can get the real data type result instead of integer data type?
Date
Msg-id 20060320211051.57D2886B12@ws7-1.us4.outblaze.com
Whole thread Raw
Responses Re: How I can get the real data type result instead of  (Sigurdur Gunnlaugsson <sig@fjolnet.net>)
Re: How I can get the real data type result instead of integer data type?  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Tree view 
In a query, there is something like

order by count(id)/age

where both id and age are the integer data type.

From a query result, I believe the operation count(id)/age yields a integer. I need it in real data type. After
searchingthe online document, I haven't found any related information. Can someone help me out on this problem, please. 

Thanks,

w

--
_______________________________________________

Search for businesses by name, location, or phone number.  -Lycos Yellow Pages

http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Double checking my logic?
Next
From: "John D. Burger"
Date:
Subject: Re: Double checking my logic?