Stupid SQL Question: - Mailing list pgsql-general

From shawn everett
Subject Stupid SQL Question:
Date
Msg-id Pine.LNX.4.30.0011141612570.9125-100000@alder.pgweb.com
Whole thread Raw
Responses Re: Stupid SQL Question:  (Michael Fork <mfork@toledolink.com>)
List pgsql-general
I have a table defined as follows:

CREATE TABLE safety (
    sid SERIAL,
    side INTEGER,
    InjDate DATE,
    InjType INTEGER,
    Outcome INTEGER,
    PRIMARY KEY (sid)
);

What I'm trying to generate is a list of all outcomes and how many of each
that occured for a particular range of dates.

This works but doesn't do dates:

SELECT outcome,count(outcome) from safety
GROUP BY outcome;

How do I incorporte dates into this query.

Adding a WHERE clause to the query doesn't work for example:

SELECT outcome,count(outcome) from safety
GROUP BY outcome
WHERE InjDate='2000-11'14';

Any tips or advice would be apreciated.

Shawn


pgsql-general by date:

Previous
From: Philip Hallstrom
Date:
Subject: Re: [ANNOUNCE] [RELEASE ANNOUNCEMENT] v7.0.3 *Final* now Available
Next
From: "Valter Mazzola"
Date:
Subject: eRserver.com Replication Server beta not available !?