Select only specific results in sql (postgresql)

Question

SELECT id, name::tsvector @@ 'substring1 & substring2'::tsquery
FROM table

I have this. The result of this query has 2 fields: id, ?column? The ?column? field value is true or false. how can I get only the true results?

fuzzyalej · Accepted Answer · 2013-03-05 14:18:33Z

1

SELECT * FROM (
  SELECT id, name::tsvector @@ 'substring1 & substring2'::tsquery
  FROM table
) AS search
WHERE column = 't'

You can also use WITH: http://www.postgresql.org/docs/9.1/static/queries-with.html

answered Mar 5, 2013 at 14:18

fuzzyalej

5,9832 gold badges33 silver badges49 bronze badges

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

Comments

Dani · Accepted Answer · 2013-03-05 14:00:50Z

0

use WHERE clause.... (if i understand your need correctly)

WHERE condition = true

answered Mar 5, 2013 at 14:00

Dani

15.1k12 gold badges69 silver badges111 bronze badges

2 Comments

Emanuele Mazzoni Over a year ago

The field ?coumn? is generated by the query, it is not contained in a table.

Dani Over a year ago

it doesn't matter - you can still use where. to make it simple you might use AS to give it a short name and use where on the short name.

amelian · Accepted Answer · 2013-03-05 14:06:03Z

0

Add a WHERE clausure to fill this values. Something like this.

SELECT id, name::tsvector @@ 'substring1 & substring2'::tsquery FROM table WHERE ?column? = 1 (or True)

answered Mar 5, 2013 at 14:06

amelian

4361 gold badge8 silver badges18 bronze badges

1 Comment

Emanuele Mazzoni Over a year ago

The field ?coumn? is generated by the query, it is not contained in a table.

Jay Walker · Accepted Answer · 2013-03-05 14:38:02Z

0

use alias to reference your column

SELECT id, name::tsvector @@ 'substring1 & substring2'::tsquery AS condition
FROM table
WHERE condition = true

edited Mar 5, 2013 at 14:38

Jay Walker

4,7315 gold badges53 silver badges54 bronze badges

answered Mar 5, 2013 at 14:11

Wldmr

1

Collectives™ on Stack Overflow

Select only specific results in sql (postgresql)

4 Answers 4

Comments

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related