Thread: what is way to specify a DOCTYPE for output from SQL/XML

Hello

I would to append a doctype declaration to result of xmlelement function.

Is it possible?

Regards

Pavel Stehule

On 05/10/11 9:07 AM, Pavel Stehule wrote:
> Hello
>
> I would to append a doctype declaration to result of xmlelement function.

like,

     select '<!DOCTYPE........>' || xmlelement(....) ....


?

2011/5/10 John R Pierce <pierce@hogranch.com>:
> On 05/10/11 9:07 AM, Pavel Stehule wrote:
>>
>> Hello
>>
>> I would to append a doctype declaration to result of xmlelement function.
>
> like,
>
>    select '<!DOCTYPE........>' || xmlelement(....) ....

yes,  it is simple way. I am interesting  about using SQL/XML functionality

Regards

Pavel Stehule

>
>
> ?
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>