Got it now.... Delphi is interfering with the numeric formatting -- obviously... this is considered normal for numeric data types that trailing zeroes are removed... they are insignificant anyway.... To solve your issue: I guess the thing to do is to cast the result as text to preserve the formatting but this will be a string instead of a number... SELECT round(12.0109, 3)::text; Greg... "Berend Tober" <btober@xxxxxxxxxxxxxxxx> wrote in message news:437CAFD4.9070805@xxxxxxxxxxxxxxxxxxx > > codeWarrior wrote: > >>If it is a numeric data column -- you probably want to use the "round" >>function: >> >>SELECT round(1200.01, 3); >>SELECT round(12.009, 2); >> >> >> > Interesting. I had tried that. After your message I tried again and > encountered this interesting anomaly: while the ROUND function used in a > query run in the SQL window of PgAdmin III does in fact force output of > trailing zero decimal digits to the extent specified, i.e., > > SELECT > project_number, > labor_hours, > TO_CHAR(labor_hours, '999.999'), > ROUND(labor_hours,3) > FROM time_data > LIMIT 5 > > "05-08",1974.0000," ###.###",1974.000 > "05-100",10810.5000," ###.###",10810.500 > "05-125",285.0000," 285.000",285.000 > "05-150",404.5000," 404.500",404.500 > "05-200",44.0000," 44.000",44.000 > > Running the same query though a TQuery dataset object in Borland Delphi > using the BDE truncates the trailing zeros from ROUND: > > 000-05-08 1974 ###.### 1974 > 000-05-100 10810.5 ###.### 10810.5 > 000-05-125 285 285.000 285 > 000-05-150 404.5 404.500 404.5 > 000-05-200 44 44.000 44 > > That is why I didn't realize ROUND was an option, but for me it still is > not since the report is produced by a Delphi application. I suppose I > can accomplish this formatting programmatically within the Delphi > application, but I was hoping to have the data base do it directly. > > Thanks, > Berend Tober > > >>"Berend Tober" <btober@xxxxxxxxxxxxxxxx> wrote in message >>news:4379F997.6050703@xxxxxxxxxxxxxxxxxxx >> >> >>>Say I want to format calculated numeric output to uniformly have a >>>specific number of decimal places, >>> > ... > -------------------------------------------------------------------------------- > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
