Tommy Gildseth wrote:
> How do you define the table name when fetching data using a join,
> union etc. where the data doesn't necessarily originate from a single
> table?

If you use the query_to_xml function, then I just write "<table>" 
without any particular name.

> Another neat feature would be if you could specify a set of columns
> which should be represented as attributes instead of nodes.

I'm sure there are plenty of possible neat features, but most of these 
can be implemented by passing the result through an XSLT 
transformation.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to