Query on a record variable

From: "Janek Sendrowski" <janek12(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Query on a record variable
Date: 2013-08-18 20:14:43
Message-ID: trinity-d97cda25-a204-4dd3-959e-b746f94fc664-1376856883089@3capp-webde-bs37
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-08-18 20:28:21 Re: Query on a record variable
Previous Message Kevin Grittner 2013-08-18 20:02:05 Re: Select performance variation based on the different combinations of using where lower(), order by, and limit