summaryrefslogtreecommitdiff
path: root/db/rest/post/api_post.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--db/rest/post/api_post.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/db/rest/post/api_post.sql b/db/rest/post/api_post.sql
index a91d9d2..b49289c 100644
--- a/db/rest/post/api_post.sql
+++ b/db/rest/post/api_post.sql
@@ -5,7 +5,8 @@ CREATE VIEW api.post AS
p.content,
p.date
FROM
- admin.post p;
+ admin.post p
+ ORDER BY id DESC;
GRANT SELECT ON TABLE api.post
TO rest_anon, rest_user;