Query on a record variable
| От | Janek Sendrowski |
|---|---|
| Тема | Query on a record variable |
| Дата | |
| Msg-id | trinity-d97cda25-a204-4dd3-959e-b746f94fc664-1376856883089@3capp-webde-bs37 обсуждение исходный текст |
| Ответы |
Re: Query on a record variable
Re: Query on a record variable |
| Список | pgsql-general |
Hi,
How can I do a query on a record variable in a function.
I want to do a dirty fulltextsearch on a table and then choose the string which have a low levenshtein-distance.
I wanted to it like this, but it doesn't work:
v_query := 'SELECT col FROM table WHERE LENGTH(dede) BETWEEN x AND y AND plainto_tsquery(string') @@ vectors';
EXECUTE v_query INTO v_rec;
v_query := 'SELECT levenshtein('string', v_rec.col) AS lev WHERE levenshtein('string', v_rec.col) < 10';
EXECUTE v_query INTO v_rec2;
Or is there an easier way to do that. Maybe just to do one query at once?
Hope someone can help me.
Janek Sendrowski
В списке pgsql-general по дате отправления: