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
