From: | Ryan Bradetich <rbrad(at)hpb50023(dot)boi(dot)hp(dot)com> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] create view as select distinct (fwd) |
Date: | 1999-04-25 19:32:02 |
Message-ID: | 199904251932.NAA16823@hpb50023.boi.hp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This is on the TODO list.
I actually have a solution that seems to work fine, but I wanted to run it past
the backend guru's after we have finished the 6.5 beta.
Sorry I din't get it finished before the beta started.
-Ryan
> Hello!
>
> VIEW on 6.4.2 ignores DISTINCT. Is it a bug? known?
>
> Oleg.
> ----
> Oleg Broytmann http://members.xoom.com/phd2/ phd2(at)earthling(dot)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(at)pirit(dot)com>
> To: Oleg Broytmann <phd(at)sun(dot)med(dot)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(at)pirit(dot)com
> Network Administrator FIDO: 2:5020/371.32
> PIRIT Corp. Phone: +7(095) 115-7101
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-04-25 19:41:29 | Re: [HACKERS] Efficiency of LIMIT ? |
Previous Message | Adam Haberlach | 1999-04-25 18:49:46 | Re: [HACKERS] Efficiency of LIMIT ? |