Re: Prepared statement's plan

From: Chris <dmagick(at)gmail(dot)com>
To: Vyacheslav Kalinin <vka(at)mgcp(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Prepared statement's plan
Date: 2008-01-17 02:16:18
Message-ID: 478EBA72.6070800@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josh Harrison 2008-01-17 03:00:04 Re: Online Oracle to Postgresql data migration
Previous Message Gregory Stark 2008-01-17 00:36:27 Re: A counter argument about DISTINCT and GROUP BY in PostgreSQL