view problem - Mailing list pgsql-general

From Dustin Sallings
Subject view problem
Date
Msg-id Pine.SGI.3.95.981106112925.19197B-100000@bleu.west.spy.net
Whole thread Raw
List pgsql-general
    I *love* 6.4.  It's fixed a tremendous amount of problems I've
been having, thank you so much.

    I did, however, find a problem with a view I created.  I'm
collecting rstat data, and the following query works great, but in a view
returns all data instead of unique data:

create view boottimes as
    select  distinct hostnames.hostname, rstat.boottime
    from    rstat, hostnames
    where   rstat.host_id=hostnames.host_id;

    Any ideas?

--
SA, beyond.com           My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________


pgsql-general by date:

Previous
From: Bill Moore
Date:
Subject: 6.1 vs 6.3.2 performance
Next
From: Bob Dusek
Date:
Subject: Re: [GENERAL] timespan