Why use ::tsvector when you have to_tsvector in Postgres?

Question

Nick · Accepted Answer · 2017-07-01 18:44:32Z

1

Just for convenience. In Postgres, you can define your own unary or binary operator or casting rule, and when you define it, you must provide a corresponding 1- or 2-argument function.

At the same time, to_tsvector(..) function is overloaded -- it can be 1-argument, or 2-argument function, and in the latter case it is possible to explicitly specify FTS configuration (sometimes it's useful to have multiple configurations). In case of 1-argument function, or ::tsvector, the default configuration (see show default_text_search_config;) will be taken.

answered Jul 1, 2017 at 18:44

Nick

2,54315 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Why use ::tsvector when you have to_tsvector in Postgres?

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