From fc8d970cbcdd6f025475822a4cf01dfda0873226 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 28 May 2003 16:04:02 +0000 Subject: Replace functional-index facility with expressional indexes. Any column of an index can now be a computed expression instead of a simple variable. Restrictions on expressions are the same as for predicates (only immutable functions, no sub-selects). This fixes problems recently introduced with inlining SQL functions, because the inlining transformation is applied to both expression trees so the planner can still match them up. Along the way, improve efficiency of handling index predicates (both predicates and index expressions are now cached by the relcache) and fix 7.3 oversight that didn't record dependencies of predicate expressions. --- src/interfaces/python/tutorial/syscat.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/interfaces/python/tutorial/syscat.py') diff --git a/src/interfaces/python/tutorial/syscat.py b/src/interfaces/python/tutorial/syscat.py index 1ab1d5840c2..46d6d46ae07 100755 --- a/src/interfaces/python/tutorial/syscat.py +++ b/src/interfaces/python/tutorial/syscat.py @@ -36,8 +36,8 @@ def list_simple_ind(pgcnx): ic.relname AS index_name, a.attname FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a WHERE i.indrelid = bc.oid AND i.indexrelid = bc.oid - AND i.indkey[0] = a.attnum AND a.attrelid = bc.oid - AND i.indproc = '0'::oid AND a.attisdropped = 'f' + AND i.indkey[0] = a.attnum AND i.indnatts = 1 + AND a.attrelid = bc.oid AND a.attisdropped = 'f' ORDER BY class_name, index_name, attname""") return result -- cgit v1.2.3