{"image_url":null,"height":"190","author_url":"https://blog.hatena.ne.jp/ikkitang1211/","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.ikkitang1211.site%2Fentry%2F2017%2F01%2F24%2F005207\" title=\"MySQL\u3057\u304b\u3084\u3063\u305f\u3053\u3068\u7121\u3044\u50d5\u304cPostgreSQL\u3078\u306e\u30c9\u30a2\u3092\u53e9\u3044\u3066\u307f\u308b\u3002\u300e\u6307\u5b9a\u3057\u305f\u30ab\u30e9\u30e0\u306b\u66f4\u65b0\u65e5\u3092\u81ea\u52d5\u3067\u5165\u308c\u3066\u304f\u308c\u308b ON UPDATE\u53e5\u306b\u3064\u3044\u3066\u300f #mysql #postgresql - \u304a\uff1f\u610f\u5916\u3068\u3044\u3051\u308b\u3084\u3093\uff01\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","description":"\u6ce8\u610f \u203b\u3059\u307f\u307e\u305b\u3093\u3002 MySQL\u306e\u8a71\u3067\u3059\u3002 PostgreSQL\u5165\u9580\u306b\u3066\u6c17\u3065\u3044\u305f\u4e8b\u3002 \u30c9\u30c3\u30c8\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb PostgreSQL\u5165\u9580 #05 \u30d5\u30a3\u30fc\u30eb\u30c9\u306b\u5236\u7d04\u3092\u3064\u3051\u3066\u307f\u3088\u3046 \u3092\u898b\u3066\u305f\u6642\u306b\u3001 \u77e5\u3063\u305f\u4e8b\u306b\u3064\u3044\u3066\u3001\u307e\u3068\u3081\u3066\u307f\u3088\u3046\u304b\u3068\u3002 check\u5236\u7d04\uff1a check(length(hoge) > 5) \u30de\u30b8\u304b\uff01 \u4f55\u3053\u306e\u5236\u7d04\uff57\uff57 \u3053\u3093\u306a\u3093\u51fa\u6765\u308b\u3093\uff1f \u3059\u3052\u3048\uff01default\u5236\u7d04: created timestamp default \u2019now\u2019 \u3002\u3002\u30de\u30b8\uff1f#postgresql #postgresql\u5165\u9580\u2014 \u30a4\u30eb\u30ab\uff20\u65b0\u7c73\u30d7\u30ed\u30b0\u30e9\u30de\u30fc (@ikkitang) 2017\u5e741\u670821\u65e5 \u9a5a\u3044\u305f\u306e\u306f\u3001default\u5236\u7d04\u2026","categories":["MySQL","PostgreSQL","Dotinstall","Database\u52c9\u5f37","\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9"],"blog_url":"https://www.ikkitang1211.site/","version":"1.0","blog_title":"\u304a\uff1f\u610f\u5916\u3068\u3044\u3051\u308b\u3084\u3093\uff01","author_name":"ikkitang1211","provider_name":"Hatena Blog","published":"2017-01-24 00:52:07","title":"MySQL\u3057\u304b\u3084\u3063\u305f\u3053\u3068\u7121\u3044\u50d5\u304cPostgreSQL\u3078\u306e\u30c9\u30a2\u3092\u53e9\u3044\u3066\u307f\u308b\u3002\u300e\u6307\u5b9a\u3057\u305f\u30ab\u30e9\u30e0\u306b\u66f4\u65b0\u65e5\u3092\u81ea\u52d5\u3067\u5165\u308c\u3066\u304f\u308c\u308b ON UPDATE\u53e5\u306b\u3064\u3044\u3066\u300f #mysql #postgresql","type":"rich","url":"https://www.ikkitang1211.site/entry/2017/01/24/005207"}