6 INSERT INTO asset.copy_tag(tag_type, label, owner ) VALUES ('bookplate', 'lp1673857_dummy_copy_tag', 1);
9 'lp1673857_dummy_copy_tag',
10 'Copy tag label can be used to set copy tag value')
12 WHERE tag_type = 'bookplate'
13 AND label = 'lp1673857_dummy_copy_tag'
17 SET value = 'jane q. smith'
18 WHERE tag_type = 'bookplate'
19 AND label = 'lp1673857_dummy_copy_tag'
25 'Copy tag value FTS works #1'
28 WHERE tag_type = 'bookplate'
29 AND label = 'lp1673857_dummy_copy_tag'
30 AND value @@ to_tsquery('jane')
36 'Copy tag value FTS works #2'
39 WHERE tag_type = 'bookplate'
40 AND label = 'lp1673857_dummy_copy_tag'
41 AND value @@ to_tsquery('jane & smith')
47 'Copy tag value FTS works #3'
50 WHERE tag_type = 'bookplate'
51 AND label = 'lp1673857_dummy_copy_tag'
52 AND value @@ to_tsquery('jane & wesson')