By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
SELECT format('<option value="%s"/>', value) AS option
FROM (VALUES ('one'), ('two'), ('three')) options(value);
| option |
|---|
| <option value="one"/> |
| <option value="two"/> |
| <option value="three"/> |
SELECT xmlelement(name "option", xmlattributes(value AS "value")) AS option
FROM (VALUES ('one'), ('two'), ('three')) options(value);
| option |
|---|
| <option value="one"/> |
| <option value="two"/> |
| <option value="three"/> |