Sybase ASE 12.5.3:
3 3.33
Regards,
Jarek
> -Wiadomość oryginalna-
> Od: Dennis Cote [mailto:[EMAIL PROTECTED]
> Wysłano: 8 lutego 2006 20:11
> Do: sqlite-users
> Temat: [sqlite] testing Avg() function in other database engines
>
> Hi All,
>
&g
In the case of PostgreSQL, avg is actually returning numeric when handed
an int.
On Wed, Feb 08, 2006 at 11:26:37AM -0800, Rich Shepard wrote:
> On Wed, 8 Feb 2006, Paul Tomblin wrote:
>
> >In PostgreSQL 7.3, I get the same:
>
> Also in postgres-8.1.2. I entered the reals with a decimal
Probably the best solution would be to have the standard implementation
activated by a PRAGMA command. This way, you don't steal functionality
from people who want non-standard implementation and you also don't risk
to break compatibility with existing software over SQLite (you have
backward
In Summary, we have 4 database engines that appear to follow the
standard, and 6 that do not.
Standard:
MS SQL 2000
Firebird 1.5
MS SQL 2005
DB2 8.2
Non-standard:
MS Access
PostgreSQL 7.3
PostgreSQL 8.1.2
MySQL 5.0
Informix 7.31
Oracle 10.1
It is also interesting
Oops...
That should, of course, be *inconsistency*.
On 2/8/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
>
> [EMAIL PROTECTED] wrote:
>
> >
> >Did you try sum(a)/count(a) instead of avg(a).
> >
> > SQLite version 3.3.3
> > Enter ".help" for instructions
> > sqlite> create table t (a integer,
[EMAIL PROTECTED] wrote:
Did you try sum(a)/count(a) instead of avg(a).
SQLite version 3.3.3
Enter ".help" for instructions
sqlite> create table t (a integer, b real);
sqlite> insert into t values (3, 3);
sqlite> insert into t values (3, 3);
sqlite> insert into t values (4, 4);
> -Original Message-
> From: Dennis Cote [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 08, 2006 2:11 PM
> To: sqlite-users
> Subject: [sqlite] testing Avg() function in other database engines
>
> Hi All,
>
> I have a question that I hope you can help with. I
FWIW, Informix 7.31 returns REALs for both averages and also for
sum(a)/count(a)
Donald Griggs
Opinions are not necessarily those of Misys Healthcare Systems nor its board
of directors.
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 08,
On 2/8/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
> create table t (a integer, b real);
> insert into t values (3, 3);
> insert into t values (3, 3);
> insert into t values (4, 4);
> select avg(a), avg(b) from t;
MySQL 5.0
3. 3.3
Firebird 1.5
3 3.33
Dennis Cote <[EMAIL PROTECTED]> wrote:
>
> I'm particularly interested in the value of avg(a). My reading of the
> standard leads me to believe that avg(a) should be 3 (i.e. an integer
> value) and not a floating point value. This is similar to the earlier
> discussion of the results for
On Wed, 8 Feb 2006, Paul Tomblin wrote:
In PostgreSQL 7.3, I get the same:
Also in postgres-8.1.2. I entered the reals with a decimal point; made no
difference.
Rich
--
Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental
Applied Ecosystem Services, Inc. (TM)
On 2/8/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I have a question that I hope you can help with. I would like to know
> what results other database engines (i.e. mySQL, PostgreSQL, Firebird,
> Oracle, MS SQL, etc) give for the following SQL.
>
> create table t (a integer, b
Quoting Dennis Cote ([EMAIL PROTECTED]):
> In SQLite I get the following:
>
>SQLite version 3.3.2
>Enter ".help" for instructions
>sqlite> create table t (a integer, b real);
>sqlite> insert into t values (3, 3);
>sqlite> insert into t values (3, 3);
>sqlite> insert into t
Hi All,
I have a question that I hope you can help with. I would like to know
what results other database engines (i.e. mySQL, PostgreSQL, Firebird,
Oracle, MS SQL, etc) give for the following SQL.
create table t (a integer, b real);
insert into t values (3, 3);
insert into t values
14 matches
Mail list logo