From faaa202b814a2ac7b1e87905fa951682d965b722 Mon Sep 17 00:00:00 2001 From: Teodor Sigaev Date: Tue, 11 Sep 2007 08:51:22 +0000 Subject: [PATCH] Fix ts_debug function to prevent unneeded calls of ts_lexize(). It will be mush better to reimplement ts_debug in C (instead of SQL as now), but it's planned for the future. --- src/backend/catalog/system_views.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/src/backend/catalog/system_views.sql b/src/backend/catalog/system_views.sql index d174720e43..b1ea8f059d 100644 --- a/src/backend/catalog/system_views.sql +++ b/src/backend/catalog/system_views.sql @@ -415,8 +415,7 @@ SELECT ( SELECT mapdict, pg_catalog.ts_lexize(mapdict, parse.token) AS lex FROM pg_catalog.pg_ts_config_map AS m WHERE m.mapcfg = $1 AND m.maptokentype = parse.tokid - ORDER BY m.mapseqno ) dl - WHERE dl.lex IS NOT NULL + ORDER BY pg_catalog.ts_lexize(mapdict, parse.token) IS NULL, m.mapseqno ) dl LIMIT 1 ) AS "Lexized token" FROM pg_catalog.ts_parse( -- 2.39.5