group by does not show error

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: group by does not show error
Date: 2012-03-24 08:06:20
Message-ID: CAGoODpe3pfA1qjU_szpF+HnLE6YR1LXcqZu1ta6mvPLjZZzTew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am using Postgresql 9.1.0.

I found that following GROUP BY query works in my DB :-

\d t1
Table "public.t1"
Column | Type | Modifiers
--------+---------+-----------
i | integer | not null
nam | text |
Indexes:
"t1_pkey" PRIMARY KEY, btree (i)

select i,nam
from t1
group by i;

i | nam
---+-----
(0 rows)

I think the query should show an error as I did not maintain group by
standard.
Does anyone know why it does not show syntax error?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2012-03-24 08:44:02 Re: group by does not show error
Previous Message Scott Marlowe 2012-03-24 07:33:09 Re: PostgreSQL 64 Bit XIDs - Transaction IDs