pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql method (initcap and also keep Roman number capitalized)
2+ messages / 2 participants
[nested] [flat]
* psql method (initcap and also keep Roman number capitalized)
@ 2018-04-27 14:39 Emi <emilu@encs.concordia.ca>
0 siblings, 1 reply; 2+ messages in thread
From: Emi @ 2018-04-27 14:39 UTC (permalink / raw)
To: pgsql-sql
Hello,
May I know is there a psql method that can do similar to initcap, and
could also keep Roman numbers (II, IV, VI, etc) to be capitalized please?
For example, string shows "Title II" but not "Title Ii".
Thanks a lot.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: psql method (initcap and also keep Roman number capitalized)
@ 2018-04-30 11:22 Martin Stöcker <martin.stoecker@stb-datenservice.de>
parent: Emi <emilu@encs.concordia.ca>
0 siblings, 0 replies; 2+ messages in thread
From: Martin Stöcker @ 2018-04-30 11:22 UTC (permalink / raw)
To: pgsql-sql@lists.postgresql.org
Hi Emi,
I think you can do this only with knowledge about the meaning of these
strings.
It is no question of psql or any other database system but of language
an logic.
Take for example "Modern Music Mix".
This can be a mix-up of music but also the 1009th part of a collection.
Or for example the car Hyundai Tucson ix, where ix doesn't mean the
number 9.
Regards Martin
Am 27.04.2018 um 16:39 schrieb Emi:
> Hello,
>
> May I know is there a psql method that can do similar to initcap, and
> could also keep Roman numbers (II, IV, VI, etc) to be capitalized please?
>
> For example, string shows "Title II" but not "Title Ii".
>
> Thanks a lot.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-04-30 11:22 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-04-27 14:39 psql method (initcap and also keep Roman number capitalized) Emi <emilu@encs.concordia.ca>
2018-04-30 11:22 ` Martin Stöcker <martin.stoecker@stb-datenservice.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox