Re: [GENERAL] Dividing Money

>>>>> "BD" == Bob Dusek <bobd(at)palaver(dot)net> writes:

BD> When I query my database, using 'select price from item_money;', postgres
BD> returns just what I asked for....

BD> (the first seven rows)

BD> price
BD> -------
BD> $4.45
BD> $2.95
BD> $4.45
BD> $2.95
BD> $3.95
BD> $3.95
BD> $3.95

BD> When I query my database using the query 'select price::float as price
BD> from item_money', I get back some wierd stuff....

BD> (the first seven rows)

BD> price
BD> ----------
BD> 1080319164
BD> 1080319108
BD> 1080319052
BD> 1080318996
BD> 1080318940
BD> 1080318884
BD> 1080318828

BD> In my first query results, the first row is the same as the third row.
BD> And, the second row is the same as the fourth row. And, rows 5,6,7 are
BD> all the same. However, in the results returned from my second query,
BD> there are not any rows of equal value.... ???

Pehaps these are _different_ sets of records? Try

select oid, price from ....

and

select oid, price::float ....

oid is unique identifyer of row. Try also use explicit order of
records, '... order by price' or by any othe field.

--
Anatoly K. Lasareff Email: tolik(at)icomm(dot)ru
Senior programmer