pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Darren Greer <dgreer@websightsolutions.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Trouble with massive select statement.
Date: Tue, 22 Jun 1999 07:08:40 -0500
Message-ID: <99062207125208.13060@george> (raw)
References: <18337.930007761@sss.pgh.pa.us>

See below

> > select distinct username, station 
> > 	from testmaster t1 
> > 	where 1 < (
> > 		select count(t2.username) 
> > 			from testmaster t2
> > 			where t2.test_date > '05-14-1999' 
> > 			and t2.station = 'WZZZ' 
> > 			and t1.username = t2.username
> > 		)
> > ;
> 
> The above doesn't seem to me to do what you claim you want to do ---
> it seems to be looking for users who have taken the test *more than
> once* in the given interval.
That is correct......my mistake :)

> Assuming that the code is right and the comment wrong ;-), I agree
Good assumption :)

> SELECT username, station FROM testmaster
>   WHERE test_date > '05-14-1999' and station = 'WZZZ' 
>   GROUP BY username, station
>   HAVING count(*) > 1;
This works wonderfully, thanks.  Now comes the other twist.  I already have a
select statement (select first_name, email from listeners l, listeners_data ld
where l.username = ld.username a nd $filter;).  The $filter is a bunch of and
statements that limit the data coming from the table listeners.  I need to get
the select statement you told me to work as a filter on the data that this
select statement grabs.  I cant see an easy way to do this without making this
thing incredibly slow having to chech every user.  Any thoughts?

Darren



view thread (5+ messages)  latest in thread

Message-ID: <99062207125208.13060@george>
Permalink:  ../99062207125208.13060@george/
Also on:    postgresql.org/message-id/99062207125208.13060@george

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: dgreer@websightsolutions.com, tgl@sss.pgh.pa.us
  Subject: Re: [SQL] Trouble with massive select statement.
  In-Reply-To: <99062207125208.13060@george>
  References: <18337.930007761@sss.pgh.pa.us> <99062207125208.13060@george>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox