Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f77LoD641790 for ; Tue, 7 Aug 2001 17:50:14 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id E3BE32AB43; Tue, 7 Aug 2001 18:49:47 -0300 (GMT) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 7A0E62AB38; Tue, 7 Aug 2001 18:49:45 -0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: "Josh Berkus" Subject: Re: views and null bothering Date: Tue, 7 Aug 2001 18:49:44 -0300 X-Mailer: KMail [version 1.2] References: In-Reply-To: Cc: pgsql sql Mailing List MIME-Version: 1.0 Message-Id: <01080718494406.11074@bugs> Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS snapshot-20010714 X-Archive-Number: 200108/111 X-Sequence-Number: 4332 On Lun 06 Ago 2001 21:02, Josh Berkus wrote: > Martin, > > > I have a bunch of tables which I give access through a view. The > > problem is > > that in the main table there are columns, that are referenced to > > another > > tables column, that have NULLs. > > In the SELECT inside the view's definition I put the join equality, > > but have > > lots of trouble makeing it put correctly the columns that have NULL > > values. > > You need to use LEFT OUTER JOIN, supported in Postgres 7.1.x. > > See the current postgresql docs, or your favorite ANSI-SQL handbook, for > guidance. Sorry for the late answer, but... THANKS ALOT! It's the first time I use OUTER JOINS, and I think they are great! Thanks Tom for this great feature. Saludos... :-) -- Cualquiera administra un NT. Ese es el problema, que cualquiera administre. ----------------------------------------------------------------- Martin Marques | mmarques@unl.edu.ar Programador, Administrador | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------