>>>>> "BD" == Bob Dusek <bobd@palaver.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@icomm.ru
Senior programmer