We do the following test on the
client site :
A)Using SQLExecDirect with this query
SELECT SUM("str_sls_totals"."strsl_net_dly"),
"dw_trans_type"."trans_type", "flash_dates"."year_number",
"flash_dates"."month_number", "flash_dates"."day"
FROM "dw_trans_type", "str_sls_totals",
On Wed, Aug 10, 2005 at 10:08:20AM -0400, Tim Nelson wrote:
So the size of SUM(str_sls_totals.strsl_net_dly) is 20. When we
change the year to 2004 the size is returned as 30 ! ! ! Is this by
design or a bug.
What is the type of that column? I'm thinking, if it's numeric, then
it's quite
The column is decimal(16,2). Thanks.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org