Re: [Gnumed-devel] re: comm views

[Karsten Hilbert]

> >I'd prefer to generate them in v_person_comms_flat
> >for people that do have some URLs, though, such that we don't
> >carry a zillion completely empty rows in that view.
> >
> this is a little better I hope,
Will add it ASAP.

> ORDER BY v1.pk_identity ;
IMO apart from *very* specialized views it doesn't make much
sense to order in views ?

> BTW, I can't find crosstab function , even though I've got 7.3 
> postgresql-contrib loaded on Mandrake 9.2
A good reason for not using it right away :-)   I'd think what
you got will suffice for now.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346