...
| Code Block |
|---|
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;
|
Returns:
| Code Block |
|---|
...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) |
film_detail_summary (function)
...