agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Dipankar Chakrabarti <dipanc@yahoo.com>
To: pgsql-sql@hub.org
Subject: Re: "order by" weirdness
Date: Mon, 27 Sep 1999 00:52:32 -0700 (PDT)
Message-ID: <19990927075232.4435.rocketmail@web117.yahoomail.com> (raw)


>Hello,

Dear Hein,

What are you trying to do with order by max(date)?

Order by date will give proper result.  For that
matter group by clause already does ordering, no need
to put a order by there.

Regards,

Dipankar

>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




__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com

view thread (7+ messages)  latest in thread

Message-ID: <19990927075232.4435.rocketmail@web117.yahoomail.com>
Permalink:  ../19990927075232.4435.rocketmail@web117.yahoomail.com/
Also on:    postgresql.org/message-id/19990927075232.4435.rocketmail@web117.yahoomail.com

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: dipanc@yahoo.com, pgsql-sql@hub.org
  Subject: Re: "order by" weirdness
  In-Reply-To: <19990927075232.4435.rocketmail@web117.yahoomail.com>

* 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