Re: showing also value '0' with aggregate count() - Mailing list pgsql-general

From Mitch Vincent
Subject Re: showing also value '0' with aggregate count()
Date
Msg-id 003001c1476d$1d7663f0$1e51000a@mitch
Whole thread Raw
In response to Re: showing also value '0' with aggregate count()  (David Christian <davidc@comtechmobile.com>)
List pgsql-general
> ERROR:  OUTER JOIN is not yet supported
> (PostgreSQL) 7.0.3
>
> do i need to upgrade or is there a workaround??

Upgrade. :-)

> > There's a great book for SQL called "The Practical SQL Handbook"
> > which covers these types of problems well.  Published by Addison
> > Wesley, written by Bowman, Emerson, and Darnovsky.  Good bedtime
> > reading. :)
>
> can you read my mind?? I am looking for a really good book on SQL. i
> will buy this and we'll see how tired i will be tomorrow..

Bruce's book is a good PostgreSQL book --
http://www.ca.postgresql.org/docs/awbook.html

-Mitch


pgsql-general by date:

Previous
From: Szabo Zoltan
Date:
Subject: Re: CREATION OF PRIMARY KEYS
Next
From: "Joel Pang"
Date:
Subject: Granting access on store procedure to other users