From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Jan Wieck <jwieck(at)debis(dot)com> |
Cc: | phd2(at)earthling(dot)net, pgsql-hackers(at)postgreSQL(dot)org, ran(at)pirit(dot)com |
Subject: | Re: [HACKERS] create view as select distinct (fwd) |
Date: | 1999-05-10 16:26:44 |
Message-ID: | 199905101626.MAA06782@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Perhaps we should issue an error message if this is attempted until we
get it working?
> Oleg Broytmann wrote:
>
> >
> > Hello!
> >
> > VIEW on 6.4.2 ignores DISTINCT. Is it a bug? known?
> >
>
> It's a known missing feature (not a bug - more like a design
> fault).
>
> DISTINCT is implemented as a unique sort step taken over the
> final result of a query. Views are implemented via the query
> rewrite rule system. If now someone would define a DISTINCT
> view and selects a join of it with another table, the rewrite
> system cannot tell the planner that only the scan's resulting
> from the view should be sorted unique. It could only tell
> that the entire result should be DISTINCT - what's wrong - so
> I left it out.
>
> I'm planning to implement some kind of subquery rangetable
> entries someday. At that time, all these problems (DISTINCT,
> GROUP BY, ORDER BY) of views will disappear.
>
>
> Jan
>
> --
>
> #======================================================================#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me. #
> #======================================== jwieck(at)debis(dot)com (Jan Wieck) #
>
>
>
>
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1999-05-10 16:28:49 | Re: [HACKERS] parser enhancement request for 6.5 |
Previous Message | Vadim Mikheev | 1999-05-10 16:23:04 | Re: [HACKERS] Pretty bad bug in Postgres. |