Re: views and null bothering

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(at)unl(dot)edu(dot)ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------