const char *query_html_post = \ "SELECT id, title, created_at::DATE, body " "FROM posts " "WHERE id = $1;"; const char *query_html_posts = \ "SELECT id, title, created_at::DATE, body " "FROM posts " "ORDER BY updated_at DESC;"; const char *query_json_post = \ "SELECT JSON_AGG(ROW_TO_JSON(row)) FROM (" "SELECT id, title, body, created_at, updated_at " "FROM posts " "WHERE id = $1" ") row;"; const char *query_json_posts = \ "SELECT JSON_AGG(ROW_TO_JSON(row)) FROM (" "SELECT id, title, body, created_at, updated_at " "FROM posts " "ORDER BY updated_at DESC" ") row;";