Re: consttraints.source

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: emkxp01(at)mtcc(dot)demon(dot)co(dot)uk
Cc: lockhart(at)alumni(dot)caltech(dot)edu, hackers(at)postgresql(dot)org
Subject: Re: consttraints.source
Date: 1998-01-06 23:56:52
Message-ID: 199801062356.SAA28485@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> Hi,
>
> I'm seeing similar problems, mainly due to failure to sort correctly
> even though there is an "order by" clause.
>
> I did a few tests and found that the sort sort seemed to fail when there
> were multiple columns in the "order by" clause. (Not conclusive)
>
> I don't know when it 1st appeared as I've been trying to compile on
> SPARC-Linux for the past few attempts and this is the 1st time I've
> had a fully working package to run the regression tests on!!

Sort is now fixed. When I added UNION, I needed to add UNIQUE from
optimizer, so I added a SortClause node to the routine. Turns out it
was NULL'ing it for every sort field. Should work now.

--
Bruce Momjian
maillist(at)candle(dot)pha(dot)pa(dot)us

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1998-01-07 00:18:19 Re: [HACKERS] database size
Previous Message Bruce Momjian 1998-01-06 23:43:30 Re: consttraints.source