Planner question regarding functions

From: Chris Travers <chris(at)travelamericas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Planner question regarding functions
Date: 2003-12-08 13:33:48
Message-ID: 1070875419.29122.6.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all;

I suspect I know what the answer here is, but I thought I would ask
anyway. How transparent are SQL language functions from the planner's
perspective? For example if I create a table:

CREATE TABLE proof_of_concept(
poc_id serial primary key,
testing text
);
and a function:

CREATE FUNCTION search_poc() RETURNS setof proof_of_concept AS '
SELECT * FROM proof_of_concept
' LANGUAGE SQL;

Then will the planner be able to use indexes if I do:
SELECT * FROM search_poc() WHERE poc_id = 16023

I am assuming it won't. But can the planner "see inside" the SQL
language functions, thus expanding them similar to a view, or will this
force a sequential scan?

Best Wishes,
Chris Travers

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2003-12-08 14:02:37 Re: UNICODE problem on 7.4 with COPY
Previous Message Bruce Momjian 2003-12-08 12:49:07 Re: pg_hba.conf change in 7.4