Re: VIEW or Stored Proc - Is this even possible?

On Wednesday 19 Feb 2003 12:56 pm, Stephen.Thompson@bmwfin.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