pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: [SQL] Re: [HACKERS] SELECT DISTINCT question
5+ messages / 3 participants
[nested] [flat]

* Re: [SQL] Re: [HACKERS] SELECT DISTINCT question
@ 1999-09-23 17:18 Bruce Momjian <maillist@candle.pha.pa.us>
  1999-09-23 21:27 ` Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 5+ messages in thread

From: Bruce Momjian @ 1999-09-23 17:18 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Hannu Krosing <hannu@trust.ee>; hackers@postgreSQL.org; pgsql-sql

Tom, any status on this DISTINCT ON ripout?


> Hannu Krosing <hannu@trust.ee> writes:
> >> "DISTINCT will eliminate all duplicate rows from the selection.
> >> DISTINCT ON column will eliminate all duplicates in the specified column;
> >> this is equivalent to using GROUP BY column."
> 
> > If it is equivalent to GROUP BY then it should allow only aggregates 
> > in non-distinct columns, like:
> > select distinct on date date, sum(bytes) from access_log;
> > If it does not, then it should be files as a bug imho.
> 
> It does not.  Whether that is a bug is hard to say, since there is no
> standard I know of that says what it *is* supposed to do.
> 
> If you look at the select_distinct_on regress test outputs, I bet you
> will be even less happy:
> 
> QUERY: SELECT DISTINCT ON string4 two, string4, ten
> 	   FROM tmp
>    ORDER BY two using <, string4 using <, ten using <;
> two|string4|ten
> ---+-------+---
>   0|AAAAxx |  0
>   0|HHHHxx |  0
>   0|OOOOxx |  0
>   0|VVVVxx |  0
>   1|AAAAxx |  1
>   1|HHHHxx |  1
>   1|OOOOxx |  1
>   1|VVVVxx |  1
> (8 rows)
> 
> That's not exactly my idea of "distinct" values of string4 ---
> but apparently whoever made up the regress test thought it was OK!
> 
> Can anyone defend this feature or provide a coherent definition
> of what it's supposed to be doing?  My urge to rip it out is
> growing stronger and stronger...
> 
> 			regards, tom lane
> 
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [SQL] Re: [HACKERS] SELECT DISTINCT question
  1999-09-23 17:18 Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Bruce Momjian <maillist@candle.pha.pa.us>
@ 1999-09-23 21:27 ` Tom Lane <tgl@sss.pgh.pa.us>
  1999-09-23 21:56   ` Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Bruce Momjian <maillist@candle.pha.pa.us>
  1999-09-23 21:58   ` Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 2 replies; 5+ messages in thread

From: Tom Lane @ 1999-09-23 21:27 UTC (permalink / raw)
  To: Bruce Momjian <maillist@candle.pha.pa.us>; +Cc: Hannu Krosing <hannu@trust.ee>; hackers@postgreSQL.org; pgsql-sql

Bruce Momjian <maillist@candle.pha.pa.us> writes:
> Tom, any status on this DISTINCT ON ripout?

I haven't done anything about it, if that's what you mean.

I didn't get any indication of whether anyone else agreed with me
(maybe the lack of loud complaints should be taken as consent?)

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [SQL] Re: [HACKERS] SELECT DISTINCT question
  1999-09-23 17:18 Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Bruce Momjian <maillist@candle.pha.pa.us>
  1999-09-23 21:27 ` Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Tom Lane <tgl@sss.pgh.pa.us>
@ 1999-09-23 21:56   ` Bruce Momjian <maillist@candle.pha.pa.us>
  1 sibling, 0 replies; 5+ messages in thread

From: Bruce Momjian @ 1999-09-23 21:56 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Hannu Krosing <hannu@trust.ee>; hackers@postgreSQL.org; pgsql-sql

> Bruce Momjian <maillist@candle.pha.pa.us> writes:
> > Tom, any status on this DISTINCT ON ripout?
> 
> I haven't done anything about it, if that's what you mean.
> 
> I didn't get any indication of whether anyone else agreed with me
> (maybe the lack of loud complaints should be taken as consent?)

I think so.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: [SQL] Re: [HACKERS] SELECT DISTINCT question
  1999-09-23 17:18 Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Bruce Momjian <maillist@candle.pha.pa.us>
  1999-09-23 21:27 ` Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Tom Lane <tgl@sss.pgh.pa.us>
@ 1999-09-23 21:58   ` Bruce Momjian <maillist@candle.pha.pa.us>
  1999-09-23 23:40     ` (no subject) Sean Mullen <sean@fastinternet.net.au>
  1 sibling, 1 reply; 5+ messages in thread

From: Bruce Momjian @ 1999-09-23 21:58 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Hannu Krosing <hannu@trust.ee>; hackers@postgresql.org; pgsql-sql

> Bruce Momjian <maillist@candle.pha.pa.us> writes:
> > Tom, any status on this DISTINCT ON ripout?
> 
> I haven't done anything about it, if that's what you mean.
> 
> I didn't get any indication of whether anyone else agreed with me
> (maybe the lack of loud complaints should be taken as consent?)

I will wrap up the mail messages, and put it on the TODO list.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* (no subject)
  1999-09-23 17:18 Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Bruce Momjian <maillist@candle.pha.pa.us>
  1999-09-23 21:27 ` Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Tom Lane <tgl@sss.pgh.pa.us>
  1999-09-23 21:58   ` Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Bruce Momjian <maillist@candle.pha.pa.us>
@ 1999-09-23 23:40     ` Sean Mullen <sean@fastinternet.net.au>
  0 siblings, 0 replies; 5+ messages in thread

From: Sean Mullen @ 1999-09-23 23:40 UTC (permalink / raw)
  To: pgsql-sql; hackers@postgreSQL.org

unsubscribe




^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~1999-09-23 23:40 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-23 17:18 Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Bruce Momjian <maillist@candle.pha.pa.us>
1999-09-23 21:27 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-09-23 21:56   ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-09-23 21:58   ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-09-23 23:40     `  Sean Mullen <sean@fastinternet.net.au>

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