On Thu, 29 Mar 2001, Vijay Deval wrote:
> URL is a very large field. If an extra field is created which gives a
> neumeric id to the url, run the query on the number, and then get the desired
> output
I have to admit, that I quite don't understand what you want me to do
here... I already have that numeric id:
> > httplog=# \d referrer
> > Table "referrer"
> > Attribute | Type | Modifier
> > -----------+--------------+----------
> > id | integer |
> > url | varchar(300) |
> > Index: referrer_pkey
If I say:
SELECT count(*), referrer.id FROM hits, referrer WHERE referrer.id =
referrer_id GROUP BY referrer.id ORDER BY count DESC LIMIT 10;
it is really fast and I get the IDs of the referrer-urls but how would I
get the URLs then?
regards,
le
--
Lukas Ertl eMail: l.ertl@univie.ac.at
WWW-Redaktion Tel.: (+43 1) 4277-14073
Zentraler Informatikdienst (ZID) Fax.: (+43 1) 4277-9140
der Universität Wien