Re: Function as Phantom Field

>>>>> "CT" == Charles Tassell <ctassell(at)isn(dot)net> writes:

CT> I have a database like this:
CT> CREATE TABLE articles (
CT> article_id serial primary key,
CT> title text
CT> );

CT> CREATE TABLE pages (
CT> article_id integer,
CT> page text
CT> );

CT> And I want to be able to do a

CT> SELECT article_id, title, count_pages(article_id) FROM articles

CT> Now, I have already written the count_pages function (it's just a count(*)
CT> where article_id = $1) but I don't know how to do the SELECT in one pass,
CT> is there some way I can do this with triggers or is there a special field
CT> name I can use to specify the current article_id as the function argument?

Try this:

select articles.article_id, count(*) from articles, pages where
article.article_id = pages.article_id group by pages.article_id;

--
Anatoly K. Lasareff Email: tolik(at)aaanet(dot)ru