Postgres Pro
Downloads
Home   >   mailing lists

Re: COUNT(*) to find records which have a certain number of - Mailing list pgsql-sql

From Greg Stark
Subject Re: COUNT(*) to find records which have a certain number of
Date
Msg-id 87fz5chjsy.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: COUNT(*) to find records which have a certain number of  (T E Schmitz <mailreg@numerixtechnology.de>)
Responses JOIN performance  ("Dean Gibson (DB Administrator)" <postgresql3@ultimeth.com>)
List pgsql-sql
Tree view 
T E Schmitz <mailreg@numerixtechnology.de> writes:

> SELECT
> BRAND_NAME,MODEL_NAME
...
> intersect
...

Huh, I never think of the set operation solutions. I'm curious how it compares
speed-wise.

-- 
greg

pgsql-sql by date:

Previous
From: Greg Stark
Date:
Subject: Re: COUNT(*) to find records which have a certain number of dependencies ?
Next
From: "Dean Gibson (DB Administrator)"
Date:
Subject: JOIN performance