Thread: pgsql functions: get column headers; optional arguments

pgsql functions: get column headers; optional arguments

From
Mark
Date:
<tt>Hi. I hope this is the correct mailing list.<br /><br /> I am writing a function to extract data either from a
tableor a query and output it in xml. I have the logic down, but I cannot work out a few things.<br /><br /> 1. How can
Iread the column headings from the returned data set? I have resorted to writing the same function in tcl in which I
canwork out how to do this, but what about pgsql? I can't use the system tables for this, since the data may not come
froma table.<br /><br /> 2. It it possible, either in tcl or pgsql, to have optional function arguments?<br /><br />
Thanks,<br/><br /> Mark<br /></tt><div class="moz-signature">-- <br /><style>#signature {    color: #00008B;
font-family:sans-serif;    font-size: 10pt;}#signature h1 {    font-size: 125%;    margin: 4px 0px;}#signature p {
margin:4px 0px;}#signature a {    color: #005247;    text-decoration: none;}
 
</style><div id="signature"><h1>Mark Simon</h1><p>Manngo Net Pty Ltd<p>Phone/Fax: 1300 726 000<br /> mobile: 0411 246
672<p>email:<a href="mailto:mark@comparity.net">mark@manngo.net</a><br /> web: <a
href="http://www.manngo.net">http://www.manngo.net</a><p>Resume:<a
href="http://mark.manngo.net">http://mark.manngo.net</a></div></div>