ADSM-L

Bad results from a SELECT ...

1998-05-12 10:16:20
Subject: Bad results from a SELECT ...
From: "Mapes, Mark" <MWM4 AT PGE DOT COM>
Date: Tue, 12 May 1998 07:16:20 -0700
Hello,

When I issue the following SELECT against the VOLUMES table, it returns the
same value for PCT_RECLAIM as it does for PCT_UTILIZED.

select volume_name as volume, pct_reclaim, pct_utilized from volumes


If I issue the following SELECT, it appears to return the proper values,
though not the same (rounding error?) as the q vol f=d.

select * from volumes.

Do you also get these similar results?

Thanks.

Mark Mapes
PG&E
<Prev in Thread] Current Thread [Next in Thread>