Обсуждение: Re: [HACKERS] create view as select distinct (fwd)

I assume this has not been fixed?



> Hello!
> 
>    VIEW on 6.4.2 ignores DISTINCT. Is it a bug? known?
> 
> Oleg.
> ---- 
>     Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
>            Programmers don't die, they just GOSUB without RETURN.
> 
> ---------- Forwarded message ----------
> Date: Fri, 23 Apr 1999 13:33:00 +0400 (MSD)
> From: Artem Chuprina <ran@pirit.com>
> To: Oleg Broytmann <phd@sun.med.ru>
> Subject: create view as select distinct
> 
> pirit=> select distinct value_at from www_counter_store;
>   value_at
> ----------
> 04-22-1999
> (1 row)
> 
> pirit=> create view www_counter_store_dates as select distinct value_at from www_counter_store;
> CREATE
> pirit=> select * from www_counter_store_dates;
> ----------
> 04-22-1999
> 04-22-1999
> 04-22-1999
> 04-22-1999
> 04-22-1999
> 04-22-1999
> 04-22-1999
> 04-22-1999
> 04-22-1999
> 04-22-1999
> 04-22-1999
> 04-22-1999
> 04-22-1999
> 04-22-1999
> 04-22-1999
> (15 rows)
> 
> -- 
> Artem Chuprina                             E-mail: ran@pirit.com
> Network Administrator                        FIDO: 2:5020/371.32
> PIRIT Corp.                              Phone: +7(095) 115-7101
> 
> 
> 


--  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,
Pennsylvania19026
 

Bruce Momjian wrote:

>
>
>
> I assume this has not been fixed?
>
>
>
> > Hello!
> >
> >    VIEW on 6.4.2 ignores DISTINCT. Is it a bug? known?
> >
> > Oleg.

    Right.  This  requires subselecting RTE's - one of the bigger
    TODO's after v6.5.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #