{"id":360,"date":"2016-03-06T15:56:36","date_gmt":"2016-03-06T12:56:36","guid":{"rendered":"http:\/\/leodev.ru\/blog\/?p=360"},"modified":"2016-03-06T20:29:43","modified_gmt":"2016-03-06T17:29:43","slug":"%d0%ba%d0%b0%d0%ba-%d0%bf%d0%be%d0%bb%d1%83%d1%87%d0%b8%d1%82%d1%8c-%d1%80%d0%b0%d0%bd%d0%b4%d0%be%d0%bc%d0%bd%d1%83%d1%8e-%d1%81%d1%82%d1%80%d0%be%d0%ba%d1%83-sql-%d0%b7%d0%b0%d0%bf%d1%80%d0%be%d1%81","status":"publish","type":"post","link":"https:\/\/leodev.ru\/blog\/news\/%d0%ba%d0%b0%d0%ba-%d0%bf%d0%be%d0%bb%d1%83%d1%87%d0%b8%d1%82%d1%8c-%d1%80%d0%b0%d0%bd%d0%b4%d0%be%d0%bc%d0%bd%d1%83%d1%8e-%d1%81%d1%82%d1%80%d0%be%d0%ba%d1%83-sql-%d0%b7%d0%b0%d0%bf%d1%80%d0%be%d1%81\/","title":{"rendered":"\u041a\u0430\u043a \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0440\u0430\u043d\u0434\u043e\u043c\u043d\u0443\u044e \u0441\u0442\u0440\u043e\u043a\u0443 SQL \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u043c \u2013 PostgreSQL"},"content":{"rendered":"<p>\u041f\u0440\u0438\u0433\u043e\u0434\u0438\u043b\u043e\u0441\u044c \u0434\u043b\u044f\u00a0\u0432\u044b\u0433\u0440\u0443\u0437\u043a\u0438 \u0440\u0430\u043d\u0434\u043e\u043c\u043d\u043e\u0439 \u043a\u0430\u0440\u0442\u0438\u043d\u043a\u0438 \u0438\u0437 \u0431\u0430\u0437\u044b<\/p>\n<p>PostgreSQL:<\/p>\n<pre class=\"lang:pgsql decode:true\">SELECT image_data FROM images ORDER BY RANDOM() limit 1;<\/pre>\n<p>MySQL<\/p>\n<pre class=\"lang:mysql decode:true\">SELECT * FROM location ORDER BY RAND() LIMIT 1<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041f\u0440\u0438\u0433\u043e\u0434\u0438\u043b\u043e\u0441\u044c \u0434\u043b\u044f\u00a0\u0432\u044b\u0433\u0440\u0443\u0437\u043a\u0438 \u0440\u0430\u043d\u0434\u043e\u043c\u043d\u043e\u0439 \u043a\u0430\u0440\u0442\u0438\u043d\u043a\u0438 \u0438\u0437 \u0431\u0430\u0437\u044b PostgreSQL: SELECT image_data FROM images ORDER BY RANDOM() limit 1; MySQL SELECT * FROM location ORDER BY RAND() LIMIT 1 &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":333,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[111,58],"class_list":["post-360","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news","tag-postgresql","tag-sql"],"_links":{"self":[{"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/posts\/360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/comments?post=360"}],"version-history":[{"count":5,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/posts\/360\/revisions"}],"predecessor-version":[{"id":372,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/posts\/360\/revisions\/372"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/media\/333"}],"wp:attachment":[{"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/media?parent=360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/categories?post=360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/leodev.ru\/blog\/wp-json\/wp\/v2\/tags?post=360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}