Re: wrong answer - Mailing list pgsql-sql

From Richard Huxton
Subject Re: wrong answer
Date
Msg-id 46CAE740.1000304@archonet.com
Whole thread Raw
In response to wrong answer  ("A. R. Van Hook" <hook@lake-lotawana.mo.us>)
List pgsql-sql
A. R. Van Hook wrote:
> I have a simple (and incorrect queuer) that gives the wrong answer.
> Can someone show me the correct syntax?
> t
> "select sum(s.ref), r.value, s.ref from registry as s          ^^^
Simple typo - you've used sum() not count()

>     qs "select count(*) from registry where ref =3"

--   Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: "A. R. Van Hook"
Date:
Subject: wrong answer
Next
From: tyrrill_ed@emc.com
Date:
Subject: Join question