gistfile1.txt

create function latest_articles(offset_arg int, limit_arg int) returns table(id text, title text, created timestamp, image text) as $$
  select pages.id, pages.title, pages.created, pages.image
  from pages, articles
  where articles.page_id = pages.id
  order by pages.created desc
  offset offset_arg
  limit limit_arg;
$$ stable language sql;

select id, title, created from latest_articles(0, 20)