| From: | chester c young <chestercyoung(at)yahoo(dot)com> |
|---|---|
| To: | ogjunk-pgjedan(at)yahoo(dot)com |
| Cc: | sql pgsql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Extracting hostname from URI column |
| Date: | 2007-09-12 03:56:19 |
| Message-ID: | 696778.6801.qm@web54301.mail.re2.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> And what I'd like is something that would give me the counts for the
> number of occurrences of each unique hostname. Something much like
> `uniq -c'. Can anyone tell me how that's done or where I should look
> for info? (I'm not sure what to look for, that's the problem).
>
select substring( ... ), count(1) from your_table group by 1;
____________________________________________________________________________________
Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ogjunk-pgjedan | 2007-09-12 03:58:16 | Re: Extracting hostname from URI column |
| Previous Message | Paul Lambert | 2007-09-12 03:53:24 | Re: Extracting hostname from URI column |