given the following table:
protocal2=> select * from sal_emp ;
name | pay_by_quarter | schedule
---+---+---
Bill | {1,1,1,1} |
{{meeting,lunch},{training,presentation}}
Carol | {200
I have 2 tables that look like this:
table1 table2
-
value1 | value2 value1 | value3 | value4
-
one| a one| a | jim
one| b one| d | bob
one| c
Exactly the same way as you posted this message - include your query, and
what you question is and we'll see what we can do.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of sahaanaa subha
Sent: Wednesday, 14 February 2007 17:45
To: pgsql-sql@postgresql.
On Wed, Feb 14, 2007 at 17:21:44 -0500,
"Edward W. Rouse" <[EMAIL PROTECTED]> wrote:
>
> I tried using coalesce(count(value4)) and case count(value4) = 0
> with no luck. I tried left and right joins and the right join gave me
> the same results while the left join gave me rows like:
That is b
