Note: I'm not 100% sure this is ready for prime time.
If the old, bad approach created:
id | source | field | value
-----+--------+-------+----------------------------------------------------------------------
178 | 47 | 5 | Concertos, piano
179 | 47 | 5 | Rapsodie sur un thème de Paganini, piano, orchestra
180 | 47 | 5 | Concertos, piano Rapsodie sur un thème de Paganini, piano, orchestra
(3 rows)
and the new approach creates:
id | source | field | value
-----+--------+-------+----------------------------------------------------------------------
180 | 47 | 5 | Concertos, piano Rapsodie sur un thème de Paganini, piano, orchestra
(1 rows)
... then it seems like there is a loss of granularity for search purposes (e.g. searching for "starts with Rapsodie").
Note: I'm not 100% sure this is ready for prime time.
If the old, bad approach created:
id | source | field | value ------- +------ -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- --
-----+-
178 | 47 | 5 | Concertos, piano
179 | 47 | 5 | Rapsodie sur un thème de Paganini, piano, orchestra
180 | 47 | 5 | Concertos, piano Rapsodie sur un thème de Paganini, piano, orchestra
(3 rows)
and the new approach creates:
id | source | field | value ------- +------ -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- --
-----+-
180 | 47 | 5 | Concertos, piano Rapsodie sur un thème de Paganini, piano, orchestra
(1 rows)
... then it seems like there is a loss of granularity for search purposes (e.g. searching for "starts with Rapsodie").
More testing needed?