Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Sat, Sep 03, 2005 at 04:29:25PM -0400, Allan Wang wrote:
>> Extra columns seem to be on sum(plays.length), videos.path, videoid
> Here's a simplified, complete test case:
Patch applied. Thanks for the test case.
regards, tom
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Sat, Sep 03, 2005 at 04:29:25PM -0400, Allan Wang wrote:
>> Extra columns seem to be on sum(plays.length), videos.path, videoid
> Here's a simplified, complete test case:
Thanks for the test case. The bug seems to be introduced by the code
I added a
On Sat, Sep 03, 2005 at 04:29:25PM -0400, Allan Wang wrote:
> I'm using 8.1 from CVS head of about two days ago.
>
> Extra columns seem to be on sum(plays.length), videos.path, videoid
Here's a simplified, complete test case:
CREATE TABLE foo (
x integer,
y integer
);
INSERT INTO foo
I'm using 8.1 from CVS head of about two days ago.
Extra columns seem to be on sum(plays.length), videos.path, videoid
create or replace view niceplays as SELECT count(*) AS plays,
summary("substring"(v.path, '[^/]+$'::text), 50) AS filename,
avg(p.length)::interval(0) AS avg, sum(p.length)::inte
