Re: wrong answer

From: Richard Huxton <dev(at)archonet(dot)com>
To: "A(dot) R(dot) Van Hook" <hook(at)lake-lotawana(dot)mo(dot)us>
Cc: postgresql sql list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: wrong answer
Date: 2007-08-21 13:23:12
Message-ID: 46CAE740.1000304@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message tyrrill_ed 2007-08-21 17:48:18 Join question
Previous Message A. R. Van Hook 2007-08-21 13:09:50 wrong answer