Re: Prepared statement's plan - Mailing list pgsql-general

From Chris
Subject Re: Prepared statement's plan
Date
Msg-id 478EBA72.6070800@gmail.com
Whole thread Raw
In response to Prepared statement's plan  ("Vyacheslav Kalinin" <vka@mgcp.com>)
List pgsql-general
Vyacheslav Kalinin wrote:
> Hello,
>
> I would appreciate if someone explained me how exactly prepared
> parametrized statements are planned

http://www.postgresql.org/docs/8.2/static/sql-prepare.html

Under the "Notes" it explains it can't use an index and has to basically
guess what it's going to do because it doesn't know what parameter you
are going to put in.

--
Postgresql & php tutorials
http://www.designmagick.com/

pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: A counter argument about DISTINCT and GROUP BY in PostgreSQL
Next
From: "Josh Harrison"
Date:
Subject: Re: Online Oracle to Postgresql data migration