Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] create view as select distinct (fwd) - Mailing list pgsql-hackers

From jwieck@debis.com (Jan Wieck)
Subject Re: [HACKERS] create view as select distinct (fwd)
Date
Msg-id m10gt5A-000EBXC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to Re: [HACKERS] create view as select distinct (fwd)  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
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) #

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Help/advice/suggestions on query optimizer for a large table
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] "op must return bool to be used with subquery"?