public.nicer_but_slower_film_list
Documentation | Pagila |
Schema | public |
Name | nicer_but_slower_film_list |
Module | Views |
The nicer_but_slower_film_list view contains a formatted view of the film table, with a comma-separated list of the film's actors.
The nicer_but_slower_film_list view differs from the film_list view in the list of actors. The lettercase of the actor names is adjusted so that the first letter of each name is capitalized, rather than having the name in all-caps.
As indicated in its name, the nicer_but_slower_film_list view performs additional processing and therefore takes longer to return data than the film_list view.
The nicer_but_slower_film_list view incorporates data from the film, category, film_category, actor, and film_actor tables.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | fid | integer | The film ID. | |||||
The film ID. |
||||||||
2 | title | character varying(255) | The title of the film. | |||||
The title of the film. |
||||||||
3 | description | text | A short description or plot summary of the film. | |||||
A short description or plot summary of the film. |
||||||||
4 | category | character varying(25) | The film category. | |||||
The film category. |
||||||||
5 | price | numeric(4, 2) | The cost to rent the film. | |||||
The cost to rent the film. |
||||||||
6 | length | smallint | The duration of the film. | |||||
The duration of the film. |
||||||||
7 | rating | USER-DEFINED | The rating assigned to the film. | |||||
The rating assigned to the film. |
||||||||
8 | actors | text | The actor's full names. | |||||
The actor's full names. |
Uses
Name |
---|
public.nicer_but_slower_film_list
|
Script
SELECT film.film_id AS fid, film.title, film.description, category.name AS category, film.rental_rate AS price, film.length, film.rating, group_concat((((upper("substring"((actor.first_name)::text, 1, 1)) || lower("substring"((actor.first_name)::text, 2))) || upper("substring"((actor.last_name)::text, 1, 1))) || lower("substring"((actor.last_name)::text, 2)))) AS actors FROM ((((category LEFT JOIN film_category ON ((category.category_id = film_category.category_id))) LEFT JOIN film ON ((film_category.film_id = film.film_id))) JOIN film_actor ON ((film.film_id = film_actor.film_id))) JOIN actor ON ((film_actor.actor_id = actor.actor_id))) GROUP BY film.film_id, film.title, film.description, category.name, film.rental_rate, film.length, film.rating; |
Exported: 2018-10-12 17:07, Last imported: 2018-08-06 09:25