Forums: general discussion (Thread #34056)

General Usage (2013-05-28 10:41 by Amit #68917)

Hello,

Are following two equivalent:

"attr_name like likequery('am')" in pg_bigm

and

"attr_name % 'am' " in pg_trgm ?

Also, is there any means to allow rank pg_bigm results based on similarity (like in pg_trgm)?

Reply to #68917×

You can not use Wiki syntax
You are not logged in. To discriminate your posts from the rest, you need to pick a nickname. (The uniqueness of nickname is not reserved. It is possible that someone else could use the exactly same nickname. If you want assurance of your identity, you are recommended to login before posting.) Login

RE: General Usage (2013-05-29 02:35 by fujii_masao #68929)

> Are following two equivalent:
>
> "attr_name like likequery('am')" in pg_bigm
>
> and
>
> "attr_name % 'am' " in pg_trgm ?

No.

> Also, is there any means to allow rank pg_bigm results based on similarity (like in pg_trgm)?

No. Because pg_bigm doesn't support the similarity search.
Reply to #68917

Reply to #68929×

You can not use Wiki syntax
You are not logged in. To discriminate your posts from the rest, you need to pick a nickname. (The uniqueness of nickname is not reserved. It is possible that someone else could use the exactly same nickname. If you want assurance of your identity, you are recommended to login before posting.) Login

RE: General Usage (2013-05-29 03:05 by sawada-masahiko #68930)

likequery() just convert condition strings into pattern of LIKE operator. And escape string such as '%'or '_' or '\' if condition string contain these characters.
(e.g. 'hoge_hoge' is converted to '%hoge\_hoge%')
Reply to #68929

Reply to #68930×

You can not use Wiki syntax
You are not logged in. To discriminate your posts from the rest, you need to pick a nickname. (The uniqueness of nickname is not reserved. It is possible that someone else could use the exactly same nickname. If you want assurance of your identity, you are recommended to login before posting.) Login