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, Pennsylvania 19026