I have a database like this:
CREATE TABLE articles (
article_id serial primary key,
title text
);
CREATE TABLE pages (
article_id integer,
page text
);
And I want to be able to do a
SELECT article_id, title, count_pages(article_id) FROM articles
Now, I have already written the count_pages function (it's just a count(*)
where article_id = $1) but I don't know how to do the SELECT in one pass,
is there some way I can do this with triggers or is there a special field
name I can use to specify the current article_id as the function argument?