Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1duePi-0002ce-UG for pgsql-docs@arkaria.postgresql.org; Wed, 20 Sep 2017 12:47:39 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1duePh-0003kp-Ui for pgsql-docs@arkaria.postgresql.org; Wed, 20 Sep 2017 12:47:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1duePJ-000363-8Z for pgsql-docs@postgresql.org; Wed, 20 Sep 2017 12:47:13 +0000 Received: from wrigleys.postgresql.org ([204.145.124.246]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dueP9-0003Si-Kr for pgsql-docs@postgresql.org; Wed, 20 Sep 2017 12:47:12 +0000 MIME-Version: 1.0 Subject: tip to workaround trailing spaces removal on char to varchar conversion To: pgsql-docs@postgresql.org From: vodevsh@gmail.com Date: Wed, 20 Sep 2017 12:46:26 +0000 Message-ID: <20170920124626.17363.48015@wrigleys.postgresql.org> Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4g bG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9z dGdyZXNxbC5vcmcvZG9jcy85LjYvc3RhdGljL2RhdGF0eXBlLWNoYXJhY3Rl ci5odG1sCkRlc2NyaXB0aW9uOgoKcmVtb3ZpbmcgdHJhaWxpbmcgc3BhY2Vz IG9uIChpbXBsaWNpdCkgY2FzdCBmcm9tIGNoYXIgdG8gdGV4dCBjYW4gYmUK cGFpbmZ1bCwgYW5kIGFsd2F5cyBzdXJwcmlzaW5nIGFzIHNob3duIGluIGV4 YW1wbGUgd2l0aCANClNFTEVDVCAmIzM5O2EgJiMzOTs6OkNIQVIoMikgY29s bGF0ZSAmcXVvdDtDJnF1b3Q7ICZsdDsgRSYjMzk7YVxuJiMzOTs6OkNIQVIo MikNCg0Kd291bGQgaXQgYmUgd29ydGggbWVudGlvbmluZyBhIHRpcCwgdGhh dCB0aGlzIGJlaGF2aW91ciBjYW4gYmUgbW9ua2V5IGhhY2tlZApieSBjb25j YXQoc3RyICZxdW90O2FueSZxdW90OyBmdW5jdGlvbiB0aGF0IGFjY2VwdHMg Y2hhciBhbmQgcmV0dXJucyB0ZXh0LCB0aHVzCnJlc3BlY3RpbmcgdGhlIHNw YWNlcywgZWcgU0VMRUNUIGNvbmNhdCgmIzM5O2EgJiMzOTs6OkNIQVIoMikg Y29sbGF0ZSAmcXVvdDtDJnF1b3Q7KSAmbHQ7CkUmIzM5O2FcbiYjMzk7OjpD SEFSKDIpIHdpbGwgcmV0dXJuIGZhbHNlIGFzIGV4cGVjdGVkLi4uCgotLSAK U2VudCB2aWEgcGdzcWwtZG9jcyBtYWlsaW5nIGxpc3QgKHBnc3FsLWRvY3NA cG9zdGdyZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNj cmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9w Z3NxbC1kb2NzCg==