agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Hein Roehrig <hein@acm.org>
To: pgsql-sql@postgresql.org
Subject: "order by" weirdness
Date: Sun, 26 Sep 1999 20:59:07 -0400
Message-ID: <E11VP8G-0005nY-00@godot.normed.de> (raw)

Hello,

consider these three statements:

create table t (id integer, date datetime ) ;
select id from t group by id ;
select id from t group by id order by max(date) ;

Is it correct behavior that the second select returns one row where
as the first select returns zero rows? 

Thanks in advance for any help,
Hein

view thread (7+ messages)  latest in thread

Message-ID: <E11VP8G-0005nY-00@godot.normed.de>
Permalink:  ../E11VP8G-0005nY-00@godot.normed.de/
Also on:    postgresql.org/message-id/E11VP8G-0005nY-00@godot.normed.de

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: hein@acm.org
  Subject: Re: "order by" weirdness
  In-Reply-To: <E11VP8G-0005nY-00@godot.normed.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox