Re: [GENERAL] ODBC issue with aggregate fields (SUM)

2005-08-10 Thread Tim Nelson
The column is decimal(16,2). Thanks. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] ODBC issue with aggregate fields (SUM)

2005-08-10 Thread Alvaro Herrera
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

[GENERAL] ODBC issue with aggregate fields (SUM)

2005-08-10 Thread Tim Nelson
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_tot

Re: [GENERAL] ODBC Issue

2003-09-09 Thread Relaxin
I realize that you guys are working on this voluntarily. All I asked was where can I go to get some questions answered. ""scott.marlowe"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Fri, 5 Sep 2003, Relaxin wrote: > > > How do we get someone from PG to respond to the questions

Re: [GENERAL] ODBC Issue

2003-09-08 Thread scott.marlowe
On Fri, 5 Sep 2003, Relaxin wrote: > How do we get someone from PG to respond to the questions in the ODBC > newsgroup? > Is the someone we can email directly? I believe your question was already answered. The issue is that in ODBC you can set it to use a cursor / fetch with a checkbox, or you