Search Postgresql Archives

pgsql functions: get column headers; optional arguments

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi. I hope this is the correct mailing list.

I am writing a function to extract data either from a table or a query and output it in xml. I have the logic down, but I cannot work out a few things.

1. How can I read the column headings from the returned data set? I have resorted to writing the same function in tcl in which I can work out how to do this, but what about pgsql? I can't use the system tables for this, since the data may not come from a table.

2. It it possible, either in tcl or pgsql, to have optional function arguments?

Thanks,

Mark
--


 Mark Simon

Manngo Net Pty Ltd

Phone/Fax: 1300 726 000
mobile: 0411 246 672

email: mark@xxxxxxxxxx <mailto:mark@xxxxxxxxxxxxx>
web: http://www.manngo.net

Resume: http://mark.manngo.net



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux