On Wednesday 19 Feb 2003 12:56 pm, Stephen(dot)Thompson(at)bmwfin(dot)com wrote:
> I have a table with fields A, B, C, D and E. Any of these can contain
> nulls. What I need to do is to be able to perform a select that removes
> nulls.
>
> if A = 'A'
> B = NULL
> C = NULL
> D = 'D'
> E = 'E'
>
> what I would like returned is
>
> A, D, E, NULL, NULL.
You could do this in 7.3 with table functions (there's a good article on
techdocs.postgresql.org about them).
Don't suppose you could give more of an explanation - it sounds like an odd
thing to do.
--
Richard Huxton