Quentin Hartman wrote:
On 5/30/06, Matthew Jarvis <[EMAIL PROTECTED]> wrote:
I'm trying to generate a php based report based on some postgres SELECT
statements...
<great suggestions snipped>
Actually, Hal Pomeranz hooked me up with the UNION syntax, which I had
forgotten about...
select count(*) as cnt, 'Touring' as interest
from contacts where interest_touring
union
select count(*) as cnt, 'Mountain' as interest
from contacts where interest_mountain
union
[... and so on ...]
Works great for this one-off reports....
Matthew S. Jarvis
IT Manager
Bike Friday - "Performance that Packs."
www.bikefriday.com
541/687-0487 x140
[EMAIL PROTECTED]
_______________________________________________
EUGLUG mailing list
[email protected]
http://www.euglug.org/mailman/listinfo/euglug
