Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Group By, NULL values and inconsistent behaviour.

From: Zeugswetter Andreas DBT <Andreas(dot)Zeugswetter(at)telecom(dot)at>
To: "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org>
Subject: Re: [HACKERS] Group By, NULL values and inconsistent behaviour.
Date: 1998-01-26 11:39:07
Message-ID: 219F68D65015D011A8E000006F8590C6010A51A7@sdexcsrv1.sd.spardat.at (view raw or flat)
Thread:
Lists: pgsql-hackers
The following is Informix behavior:

informix(at)zeus:/usr/informix72> dbaccess - -
> create database nulltest in datadbs;
Database created.

> create table t1 (a int4, b char(2), c char(2));
  201: A syntax error has occurred.
Error in line 1
Near character position 20

> create table t1 (a int, b char(2), c char(2));
Table created.

> insert into t1 (a,c) values (1,'x');
1 row(s) inserted.
> insert into t1 (a,c) values (2,'x');
1 row(s) inserted.
> insert into t1 (a,c) values (3,'z');
1 row(s) inserted.
> insert into t1 (a,c) values (2,'x');
1 row(s) inserted.
> select * from t1;
          a b  c
          1    x
          2    x
          3    z
          2    x

4 row(s) retrieved.
> select b,c,sum(a) from t1 group by b,c;
b  c             (sum)

   x                 5
   z                 3

2 row(s) retrieved.
> select b,c,sum(a) from t1 group by b,c order by c;
b  c             (sum)

   x                 5
   z                 3

2 row(s) retrieved.
>


Andreas

pgsql-hackers by date

Next:From: Zeugswetter Andreas DBTDate: 1998-01-26 11:51:54
Subject: Re: [HACKERS] Group By, NULL values and inconsistent behaviour.
Previous:From: Andrew MartinDate: 1998-01-26 10:40:32
Subject: Re: [HACKERS] Re: [QUESTIONS] How is PostgreSQL doing?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group