Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: a row disapearing
- From: Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com>
- To: Nis Jorgensen <nis(at)superlativ(dot)dk>
- Cc: pgsql-general(at)postgresql(dot)org, Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
- Subject: Re: a row disapearing
- Date: Mon, 29 May 2006 12:56:08 +0200
- Message-id: <1148900168(dot)14902(dot)45(dot)camel(at)model(dot)home(dot)waw(dot)pl>
On Mon, 2006-05-29 at 12:32 +0200, Nis Jorgensen wrote: > Rafal Pietrak wrote: > > But is there a way to achieve one row output with both the count() and > > its selector, when the ocunt is ZERO? > SELECT dummy.id, count(xxx.id) FROM (SELECT :id as id FROM dual) as > dummy LEFT JOIN xxx using (id) GROUP BY id; > > You owe the Oracle a natural left join replacement. Luckily I've already figured that out, after Richard hinted me on using a JOIN. Thenx! -- -R
- Follow-Ups:
- UTF-8 context of BYTEA datatype??
- From: Rafal Pietrak
- UTF-8 context of BYTEA datatype??
- References:
- Re: a row disapearing
- From: Bruce Momjian
- Re: a row disapearing
- From: Rafal Pietrak
- Re: a row disapearing
- From: Nis Jorgensen
- Re: a row disapearing
- Prev by Date: Re: a row disapearing
- Next by Date: Re: Best open source tool for database design / ERDs?
- Previous by thread: Re: a row disapearing
- Next by thread: UTF-8 context of BYTEA datatype??
- Indexes: