sql query with multiple values

Question

How can I get this query to query multiple values?

This works. Look at the last line:

    SELECT part_groups, part_categories, critical_part, part_groups_count, project FROM 
    (SELECT part_groups.name as part_groups, part_groups.critical_part as critical_part, part_categories.name as part_categories, projects.action_code as project, COUNT(part_groups.id) as part_groups_count, to_tsvector(part_groups.name) || to_tsvector(part_categories.name) || to_tsvector(projects.action_code) as document 
    FROM part_groups 
    CROSS JOIN projects 
    CROSS JOIN phases 
    JOIN part_categories ON part_categories.id = part_groups.part_category_id 
    GROUP BY part_groups.name, part_groups.critical_part, part_categories.name, projects.action_code, phases.name) 
    p_search WHERE p_search.document @@ to_tsquery('queryOne');

This doesn't not work. Again last line:

    SELECT part_groups, part_categories, critical_part, part_groups_count, project FROM 
    (SELECT part_groups.name as part_groups, part_groups.critical_part as critical_part, part_categories.name as part_categories, projects.action_code as project, COUNT(part_groups.id) as part_groups_count, to_tsvector(part_groups.name) || to_tsvector(part_categories.name) || to_tsvector(projects.action_code) as document 
    FROM part_groups 
    CROSS JOIN projects 
    CROSS JOIN phases 
    JOIN part_categories ON part_categories.id = part_groups.part_category_id 
    GROUP BY part_groups.name, part_groups.critical_part, part_categories.name, projects.action_code, phases.name) 
    p_search WHERE p_search.document @@ to_tsquery('queryOne', 'queryTwo');

@Joe yeah, that would be a problem. However, not my problem. that was just a typo in my question. The query I was running actually had the quotes right. Apologies :) — bonum_cete
– bonum_cete, Commented Dec 9, 2014 at 22:42

Gordon Linoff · Accepted Answer · 2014-12-09 22:51:49Z

1

I am not aware that to_tsquery takes multiple query arguments. Try this:

WHERE p_search.document @@ to_tsquery('queryOne | queryTwo')

or

WHERE p_search.document @@ to_tsquery('queryOne & queryTwo')

depending on your intention.

answered Dec 9, 2014 at 22:51

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sql query with multiple values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related