MIME-Version: 1.0
References: <CANzqJaAJVQVa0Wbx1fHv5n7zfp9ZyCXZMPqJF_JLTBo68ToNeA@mail.gmail.com>
In-Reply-To: <CANzqJaAJVQVa0Wbx1fHv5n7zfp9ZyCXZMPqJF_JLTBo68ToNeA@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 27 Aug 2025 18:12:48 -0400
Message-ID: <CAKAnmmKv=A6d=q_CqYPP6a7qS2+tacYV4WOzXziBuXq3MPTwjw@mail.gmail.com>
Subject: Re: psql --html and to_char()
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ec2ef4063d6018bb"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmKv%3DA6d%3Dq_CqYPP6a7qS2%2BtacYV4WOzXziBuXq3MPTwjw%40mail.gmail.com>
Precedence: bulk

--000000000000ec2ef4063d6018bb
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Aug 27, 2025 at 11:28=E2=80=AFAM Ron Johnson <ronljohnsonjr@gmail.c=
om>
wrote:

> Is there a way around this, other than writing my own HTMLifier?
>

Not unless your to_char() output can be coerced back into a numeric. (for
the archives sake, see fe_utils/print.c for the complete list of
right-aligned columns: int family, float, numeric, oid, xid, cid, and the
when-will-it-finally-die money type)

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

--000000000000ec2ef4063d6018bb
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Aug 27, 2025 at 11:28=E2=80=AFAM =
Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gm=
ail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container=
"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;borde=
r-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>I=
s there a way around this, other than writing my own HTMLifier?</div></div>=
</blockquote><div><br></div><div>Not unless your to_char() output can be co=
erced back into a numeric. (for the archives sake, see fe_utils/print.c for=
 the complete list of right-aligned columns: int family, float, numeric, oi=
d, xid, cid, and the when-will-it-finally-die money type)</div><div>=C2=A0<=
/div></div>Cheers,<div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"lt=
r"><div>Greg</div><div><br></div><div>--</div><div>Crunchy Data - <a href=
=3D"https://www.crunchydata.com" target=3D"_blank">https://www.crunchydata.=
com</a></div><div>Enterprise Postgres Software Products &amp; Tech Support<=
/div><div><br></div></div></div></div>

--000000000000ec2ef4063d6018bb--