There is a change in html output construction in the 7.1 series that I have had difficulty handling. In a prior version (7.0.x, I think) invoking psql with -H command line switch and a select statement of the following form: select '<a href="' || table.url || '">' || 'link text </a>' from table where .... produced a html table with "clickable" links. In 7.1.3, if html output is selected, the angle brackets are output as < or > . I see the need for the change in this behaviour, but it hampers my use of postgresql to generate html tags. Modifying the select statement to include hex or octal character equivalents for the angle brackets produces the same results as does use of the 〈 / 〉 constructs. Short of outputing the query results as text and generating the html on my own, is there an intrinsic postgresql solution to this issue? -- Marc Zuckman [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
