Postgres Pro
Downloads
Home   >   mailing lists

Re: 'foreign key with default null' problem in allergies view - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: 'foreign key with default null' problem in allergies view
Date
Msg-id 20030503012447.J4463@hermes.hilbert.loc
Whole thread Raw
In response to 'foreign key with default null' problem in allergies view  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Tree view 
Problem solved. Quick follow-up for those in the learning like
me: One needs to use a left outer join on allergy and
clin_narrative:

... from (allergy a left outer join clin_narrative cn on (a.id_comment=cn.id)) ...

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

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: PSQL by itself?
Next
From: Benjamin Scherrey
Date:
Subject: Status of OIDs was: Re: select first occurrence of a table