{"width":"100%","provider_url":"https://hatena.blog","image_url":null,"version":"1.0","author_url":"https://blog.hatena.ne.jp/shuzo_kino/","type":"rich","published":"2016-12-11 23:40:32","blog_title":"Bye Bye Moore","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fshuzo-kino.hateblo.jp%2Fentry%2F2016%2F12%2F11%2F234032\" title=\"postgres\u306eto_char\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8 - Bye Bye Moore\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","author_name":"shuzo_kino","url":"https://shuzo-kino.hateblo.jp/entry/2016/12/11/234032","categories":["sql"],"title":"postgres\u306eto_char\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8","description":"\u7b26\u53f7\u4ed8\u304d select to_char(-123,'SG999') as id; id ------ -123 (1 row) \u30ed\u30fc\u30de\u6570\u5b57 > SELECT to_char(99,'RN') AS id; id\u2014\u2014\u2014\u2014XCIX\u30ed\u30fc\u30de\u6570\u5b57\u306b\u5909\u63db\u3057\u3066\u304f\u308c\u308b\u3093\u3067\u3059\u304b\u301c\u3053\u308a\u3083\u4fbf\u5229\u6a5f\u80fd\u3060\u301c\uff08\u3050\u308b\u3050\u308b\u76ee#postgresql\u2014 \u6728\u91ce\u4fee\u9020 (@shuzo_kino) 2016\u5e7412\u67089\u65e5 \u30ed\u30fc\u30de\u6570\u5b57\u306b\u3082\u30b3\u30f3\u30d0\u30fc\u30c8\u3067\u304d\u307e\u3059\u3002 \u5730\u5473\u306b\u9762\u5012\u306a\u6a5f\u80fd\u3067\u3059\u3057 SELECT to_char(99,'RN') AS id; #> id #> \u2014\u2014\u2014\u2014 #> XCIXSELECT to_char(2016,'RN') AS \u2026","blog_url":"https://shuzo-kino.hateblo.jp/"}