Skip to main content
deleted 304 characters in body
Source Link

I need an advice with searching of record based on specified string. In the table I have columns like:

  • country
  • city
  • street
  • house number
  • post code

Search strings can contain values from these columns. Values in this string don´t have to be strictly identical given in the correct order and also the values of some columns in this string may be missing.
Example of table record:

|country|city|street         |house number|post code|
|-------|----|---------------|------------|---------|
|Austria|Wien|Kärntner Strabe|22          |2000     |

Example of search string:

22 Karntner Wien

And I get for example result with top 5 similar records.

I think I should use full text search, but I have no experiences with it. Can you tell me how to proceed?

I need an advice with searching of record based on specified string. In the table I have columns like:

  • country
  • city
  • street
  • house number
  • post code

Search strings can contain values from these columns. Values in this string don´t have to be strictly identical given in the correct order and also the values of some columns in this string may be missing.
Example of table record:

|country|city|street         |house number|post code|
|-------|----|---------------|------------|---------|
|Austria|Wien|Kärntner Strabe|22          |2000     |

Example of search string:

22 Karntner Wien

And I get for example result with top 5 similar records.

I think I should use full text search, but I have no experiences with it. Can you tell me how to proceed?

I need an advice with searching of record based on specified string.

Search strings can contain values from these columns. Values in this string don´t have to be strictly identical given in the correct order and also the values of some columns in this string may be missing.

Example of search string:

22 Karntner Wien

And I get for example result with top 5 similar records.

I think I should use full text search, but I have no experiences with it. Can you tell me how to proceed?

Tweeted twitter.com/StackDBAs/status/831394946548641792
various minor edits, tag
Source Link
Erwin Brandstetter
  • 182.2k
  • 28
  • 457
  • 620

I need an advice with searching of record based on specified string. In the table I have coulmnscolumns like:

  • country
  • city
  • street
  • house number
  • post code

StringSearch strings can contains somecontain values from these columns. Values in this string don´t have to be strictly identical given in the correct order and also the values of some columns in this string may be missing. 
Example of table record:

|country|city|street         |house number|post code|
|-------|----|---------------|------------|---------|
|Austria|Wien|Kärntner Strabe|22          |2000     |

Example of search string under which it will seek entry:

22 Karntner Wien

And I get for example result with top 5 similar records.

I think iI should use fulltextfull text search, but I have not anyno experiences with thisit. Can you tell me how to proceed? Thanks

I need an advice with searching of record based on specified string. In the table I have coulmns like

  • country
  • city
  • street
  • house number
  • post code

String can contains some values from these columns. Values in this string don´t have to be strictly identical given in the correct order and also the values of some columns in this string may be missing. Example of table record:

|country|city|street         |house number|post code|
|-------|----|---------------|------------|---------|
|Austria|Wien|Kärntner Strabe|22          |2000     |

Example of string under which it will seek entry:

22 Karntner Wien

And I get for example result with top 5 similar records.

I think i should use fulltext search, but I have not any experiences with this. Can you tell me how to proceed? Thanks

I need an advice with searching of record based on specified string. In the table I have columns like:

  • country
  • city
  • street
  • house number
  • post code

Search strings can contain values from these columns. Values in this string don´t have to be strictly identical given in the correct order and also the values of some columns in this string may be missing. 
Example of table record:

|country|city|street         |house number|post code|
|-------|----|---------------|------------|---------|
|Austria|Wien|Kärntner Strabe|22          |2000     |

Example of search string:

22 Karntner Wien

And I get for example result with top 5 similar records.

I think I should use full text search, but I have no experiences with it. Can you tell me how to proceed?

Source Link

PostgreSQL full text search on many columns

I need an advice with searching of record based on specified string. In the table I have coulmns like

  • country
  • city
  • street
  • house number
  • post code

String can contains some values from these columns. Values in this string don´t have to be strictly identical given in the correct order and also the values of some columns in this string may be missing. Example of table record:

|country|city|street         |house number|post code|
|-------|----|---------------|------------|---------|
|Austria|Wien|Kärntner Strabe|22          |2000     |

Example of string under which it will seek entry:

22 Karntner Wien

And I get for example result with top 5 similar records.

I think i should use fulltext search, but I have not any experiences with this. Can you tell me how to proceed? Thanks