Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1fD6p1-0002BA-38
	for pgsql-sql@arkaria.postgresql.org; Mon, 30 Apr 2018 11:18:19 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1fD6oz-0000WL-Bt
	for pgsql-sql@arkaria.postgresql.org; Mon, 30 Apr 2018 11:18:17 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <martin.stoecker@stb-datenservice.de>)
	id 1fD6oz-0000WB-0K
	for pgsql-sql@lists.postgresql.org; Mon, 30 Apr 2018 11:18:17 +0000
Received: from mail.inqbus.de ([164.177.165.236])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <martin.stoecker@stb-datenservice.de>)
	id 1fD6oq-0003lF-W0
	for pgsql-sql@lists.postgresql.org; Mon, 30 Apr 2018 11:18:15 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=stb-datenservice.de; s=20160215; h=Content-Type:In-Reply-To:MIME-Version:
	Date:Message-ID:From:References:To:Subject:Sender:Reply-To:Cc:
	Content-Transfer-Encoding:Content-ID:Content-Description:Resent-Date:
	Resent-From:Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:
	List-Help:List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive;
	 bh=QHvRomAlte5q6rUo2Jziae2T+g/kuy1XsGFIVJ1HElg=; b=mHybFRECFr4Bk7ph5Z78PjSuu
	FBPHxGdz5GWebau+0yWG4jA8goWPxa/Yyfjkq0FL5/U/cgdxAfco06RrnTsvBzi+kAVdjA88ZYvgm
	/R+zeGCylum2xSXT7rxoUoV5KmxRvUFd+gRDUPBpgAJvM2sbJeAAdMdKtGnTKj4LvMPoI=;
Received: from x4db4ce1b.dyn.telefonica.de ([77.180.206.27]:59996
 helo=[192.168.178.20])
	by mail.inqbus.de with esmtpa (Exim 4.89)
	(envelope-from <martin.stoecker@stb-datenservice.de>)
	id 1fD6on-00062V-8f
	for pgsql-sql@lists.postgresql.org; Mon, 30 Apr 2018 13:18:05 +0200
Subject: Re: psql method (initcap and also keep Roman number capitalized)
To: pgsql-sql@lists.postgresql.org
References: <2bdf8140-48a0-24fc-acd4-14739b973357@encs.concordia.ca>
From: =?UTF-8?Q?Martin_St=c3=b6cker?= <martin.stoecker@stb-datenservice.de>
Message-ID: <de600de8-9f42-df27-b894-357fd88ae061@stb-datenservice.de>
Date: Mon, 30 Apr 2018 13:22:31 +0200
User-Agent: Mozilla/5.0 (Windows NT 6.0; rv:52.0) Gecko/20100101
 Thunderbird/52.7.0
MIME-Version: 1.0
In-Reply-To: <2bdf8140-48a0-24fc-acd4-14739b973357@encs.concordia.ca>
Content-Type: multipart/alternative;
 boundary="------------CC1235F6D3D14D87CDFA28FC"
Content-Language: de
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Precedence: bulk

This is a multi-part message in MIME format.
--------------CC1235F6D3D14D87CDFA28FC
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

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.


--------------CC1235F6D3D14D87CDFA28FC
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    Hi Emi,<br>
    <br>
    I think you can do this only with knowledge about the meaning of
    these strings.<br>
    It is no question of psql or any other database system but of
    language an logic.<br>
    <br>
    Take for example "Modern Music Mix".<br>
    This can be a mix-up of music but also the 1009th part of a
    collection.<br>
    <br>
    Or for example the car Hyundai Tucson ix, where ix doesn't mean the
    number 9.<br>
    <br>
    Regards Martin<br>
    <br>
    <div class="moz-cite-prefix">Am 27.04.2018 um 16:39 schrieb Emi:<br>
    </div>
    <blockquote type="cite"
      cite="mid:2bdf8140-48a0-24fc-acd4-14739b973357@encs.concordia.ca">
      <meta http-equiv="content-type" content="text/html; charset=utf-8">
      <font size="-2">Hello,<br>
        <br>
        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?<br>
        <br>
        For example, string shows "Title II" but not "Title Ii".<br>
        <br>
        Thanks a lot.<br>
      </font> </blockquote>
    <br>
  </body>
</html>

--------------CC1235F6D3D14D87CDFA28FC--