-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 11/01/06 23:43, Martin Kuria wrote: > Dear Richard, > > Thanks for your response, you are right I am trying to do headings, I > thought I could do it from writing a SQL statement, but as you have > suggested it can only be achieved on the client code, I wish one day it > can be achieved with a SQL Statament thanks again . You can do it in PL/pgSQL. - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFSfvMS9HxQb37XmcRAp/PAKCZN+KqofcbbitG4RdAQggspANOWQCg68vT d0/UAVvZFLZlfLWjSRtmga4= =fftQ -----END PGP SIGNATURE-----