[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] re: v_person_comms_flat
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] re: v_person_comms_flat |
Date: |
Tue, 1 Feb 2005 20:43:16 +0100 |
User-agent: |
Mutt/1.3.22.1i |
> the simplification done recently on v_person_comms_flat doesn't work.
>
> It will only return a row if instances of all five types of comm
> channels are present for an identity.
>
> The previous version generated blank rows for comm channel types where
> there were no entries.
> ANDing (inner joining) across all five types would work, because where
> there was at least one
> entry for a comm type for an identity, any missing comm type entries
> were substituted with rows
> with blank urls.
>
> Please test both versions before replacing old and new versions. There
> is no way
> the replacement could have been made if it had been tested even in a
> basic way.
Will take a look this week. Likely you are right. I don't
remember liking that change (though I did not speak up against
it either).
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346