[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] some comm convenience views
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] some comm convenience views |
Date: |
Fri, 25 Jun 2004 17:08:07 +0200 |
User-agent: |
Mutt/1.3.22.1i |
v_linked_comms has been added as v_pat_comms with some naming
changes to reflect coding style. In it's current form this
view will produce (no_of_identities * no_of_comm_types) rows.
Is this really what is intended ? I would prefer producing
rows only for existing comm links, eg. a straightforward
denormalization of lnk_identity2comm_chan, and checking for
len(rows) == 0 in the application.
> for that type and identity. v_flat_comms uses v_linked_comms to put all
> the urls for each identity under respective field names.
> I tried to do it using left joins , but this produced illegal rows.
You'll need contrib/crosstab for that.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346