Re: row numbering - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: row numbering
Date
Msg-id 20050301174345.B623@hermes.hilbert.loc
Whole thread Raw
In response to Re: row numbering  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: row numbering
List pgsql-general
> > There are 5 vaccinations in a given vaccination schedule.
> >
> > Patient had 3 shots.
> >
> > I want the view to show me that shot 4 and 5 are missing
> > without having to enter the cardinality of the vaccination in
> > the original data.
>
> For this kind of task you usually want to use a left (or right) join.
I thought so. I tried to get it done that way several
times. I asked on this list more than once, too.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: multicolumn GIST index question
Next
From: Karsten Hilbert
Date:
Subject: Re: row numbering