Re: [SQL] References NULL field

2006-04-02 Thread Michael Fuhr
On Sun, Apr 02, 2006 at 11:43:34PM -0400, Paul M Foster wrote: > I want to do a query (in PHP, FWIW) that returns all the fields in > registrars, and the contents of any relevant notes records, or null for > those fields if there is no corresponding record in the notes table. But > when I do > > S

[SQL] References NULL field

2006-04-02 Thread Paul M Foster
This is PostgreSQL 7.4 (long story). I have a table, registrars, which has, among other things, note_id integer references notes The notes table has, among other things, note_id integer default nextval('notes_seq') Right now, there's nothing in the notes table, and all the records in the regis