| From: | Luca Ferrari <fluca1978(at)infinito(dot)it> |
|---|---|
| To: | Enrico Oliva <oliva(dot)enrico(at)gmail(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: xmlElement and \n |
| Date: | 2013-09-19 08:52:36 |
| Message-ID: | CAKoxK+4XfYuj8ZJS=abL5hF3h0TvOMoRi28+WF3BA5q9tenoWQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, Sep 19, 2013 at 9:46 AM, Enrico Oliva <oliva(dot)enrico(at)gmail(dot)com> wrote:
> I would like to have
> <IDXS>
> <IDX name="as001_c01pk">
> <IDX_IS_UNIQUE>Yes</IDX_IS_UNIQUE>
> ...
I'm not sure there is an indenting facility, since indentation
strongly depends on what the user think about.
However you can concatenate a new line at each xmlelement call:
SELECT xmlelement(name foo, xmlattributes(current_date as bar),
'cont', 'ent') || chr(10) || 'hello world'
Luca
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ssylla | 2013-09-20 07:52:28 | detect initiator of update/delete action |
| Previous Message | Enrico Oliva | 2013-09-19 07:46:51 | xmlElement and \n |