Page Comparison

begin;
select cinefiles_denorm.doc_detail_summary('12', 'document', 'doctitle', 'authors', 'source', 'doctype', 'lang', 'docsubj', 'docnamesubj', 'docfilmsubj', 'docurl');
fetch all in "document";
fetch all in "doctitle";
fetch all in "authors";
fetch all in "source";
fetch all in "doctype";
fetch all in "lang";
fetch all in "docsubj";
fetch all in "docnamesubj";
fetch all in "docfilmsubj";
fetch all in "docurl";
commit;

content  | doc_id |    date     | pages | pg_info | cast_cr | tech_cr | bx_info
 | filmog | dist_co | prod_co | cost | illust | note
----------+--------+-------------+-------+---------+---------+---------+--------
-+--------+---------+---------+------+--------+------
 Document |     12 | 1989 Aug 06 |     2 | p. H-15 |       0 |       0 |       0
 |      0 |       0 |       0 |    1 |      0 |
(1 row)

    content     |                title
----------------+-------------------------------------
 Document Title | The abyss: a foray into deep waters
(1 row)

     content      | name_id |     author
------------------+---------+----------------
 Document Authors |       2 | Aljean Harmetz
(1 row)

     content     |     src_id      |     source     | srcurl
-----------------+-----------------+----------------+--------
 Document Source | organization482 | New York Times |
(1 row)

    content    |  type
---------------+--------
 Document Type | review
(1 row)

      content       |  lang
--------------------+---------
 Document Languages | English
(1 row)

      content      | subj_id |           subj
-------------------+---------+---------------------------
 Document Subjects |       2 | Underwater cinematography
(1 row)

        content         | name_id |                    namesubj

------------------------+---------+---------------------------------------------
----
 Document Name Subjects |       2 | James Cameron, Kapuskasing, Ontario, Canada
 Document Name Subjects |       2 | Ed Harris, Englewood, New Jersey, United Sta
tes
(2 rows)

        content         | film_id  |            filmsubj
------------------------+----------+--------------------------------
 Document Film Subjects | pfafilm2 | The abyss, James Cameron, 1989
(1 row)

   content    | docurl
--------------+--------
 Document URL |
(1 row)

begin;
select cinefiles_denorm.film_detail_summary('pfafilm3','title', 'director', 'country', 'filmyear', 'lang', 'prodco', 'genre', 'subject', 'reldocs');
fetch all in "title";
fetch all in "director";
fetch all in "country";
fetch all in "filmyear";
fetch all in "lang";
fetch all in "prodco";
fetch all in "genre";
fetch all in "subject";
fetch all in "reldocs";
commit;