{"id":1142,"date":"2012-07-20T13:15:52","date_gmt":"2012-07-20T04:15:52","guid":{"rendered":"https:\/\/gunmagisgeek.com\/wordpress\/?p=1142"},"modified":"2013-12-30T01:41:25","modified_gmt":"2013-12-29T16:41:25","slug":"post-1142","status":"publish","type":"post","link":"https:\/\/gunmagisgeek.com\/blog\/sql\/1142","title":{"rendered":"[SQL] \u6570\u5b57\u3092\u542b\u3080\u6587\u5b57\u5217\u3092\u6bd4\u8f03\u3059\u308b\u306b\u306f\uff1f"},"content":{"rendered":"<p>\u5b8c\u5168\u306b\u500b\u4eba\u7684\u306a\u30e1\u30e2<\/p>\n<p>\u300c1R\u300d\u3068\u304b\u300c2DK\u300d\u3068\u304b\u300c3LDK\u300d\u3068\u3044\u3063\u305f\u6587\u5b57\u30c7\u30fc\u30bf\u306e\u5165\u3063\u305f\u30ab\u30e9\u30e0\u3092\u30bf\u30fc\u30b2\u30c3\u30c8\u306b\u3001&#8221;\uff14\u90e8\u5c4b\u4ee5\u4e0a&#8221;\u3001&#8221;\uff14\u90e8\u5c4b\u4ee5\u4e0b&#8221;\u3068\u3044\u3063\u305f\u6761\u4ef6\u3067\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\u305f\u3044\u3002<\/p>\n<p>\u30e1\u30f3\u30c9\u30a6\u306a\u3053\u3068\u306b\u3001\u3053\u306e\u30ab\u30e9\u30e0\u306b\u306f\u300c\u4e8b\u52d9\u6240\u300d\u3068\u304b\u300c\u5e97\u8217\u300d\u3068\u304b\u6570\u5024\u306e\u542b\u307e\u308c\u306a\u3044\u30c7\u30fc\u30bf\u3082\u5165\u3063\u3066\u3044\u308b\u3002<\/p>\n<p>\u30c6\u30fc\u30d6\u30eb\u540d\u306f\u300choge_tb\u300d\u30ab\u30e9\u30e0\u540d\u306f\u300croom\u300d<\/p>\n<p>\u3068\u308a\u3042\u3048\u305a\u3001\u601d\u3044\u3064\u3044\u305f\u306e\u304c\u4ee5\u4e0b<\/p>\n<pre class=\"lang:pgsql decode:true \" title=\"4\u90e8\u5c4b\u4ee5\u4e0a\u62bd\u51fa\">SELECT * FROM hoge_tb WHERE  to_number(('0' || room), '99')&gt;=4 \r\n<\/pre>\n<pre class=\"lang:pgsql decode:true \" title=\"4\u90e8\u5c4b\u4ee5\u4e0b\u62bd\u51fa\">SELECT * FROM hoge_tb WHERE   to_number(('0' || room), '99')&lt;=4 AND to_number(('0' || room), '99')&lt;&gt;0 \r\n<\/pre>\n<p>\u3046\uff5e\u3093\u3001\u3042\u307e\u308a\u7dba\u9e97\u304f\u306a\u3044\u3002<br \/>\n\u3082\u3063\u3068\u3001\u3044\u3044\u65b9\u6cd5\u304c\u306a\u3044\u304b\u306a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5b8c\u5168\u306b\u500b\u4eba\u7684\u306a\u30e1\u30e2 \u300c1R\u300d\u3068\u304b\u300c2DK\u300d\u3068\u304b\u300c3&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[],"class_list":["post-1142","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/posts\/1142","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/comments?post=1142"}],"version-history":[{"count":23,"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/posts\/1142\/revisions"}],"predecessor-version":[{"id":1165,"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/posts\/1142\/revisions\/1165"}],"wp:attachment":[{"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/media?parent=1142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/categories?post=1142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gunmagisgeek.com\/blog\/wp-json\/wp\/v2\/tags?post=1142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}