From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Question about stored procedures |
Date: | 2006-06-12 12:23:48 |
Message-ID: | 20060612122348.GA55839@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Mon, Jun 12, 2006 at 11:15:28AM +0200, A. Kretschmer wrote:
> am 12.06.2006, um 10:58:04 +0200 mailte Greg folgendes:
> > i.e I would like the query to be "select name, email from users where userid
> > = @userid"
>
> If you want to execute dynamic querys, read
>
> http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
The above query doesn't need to be dynamic if @userid is the only
part that varies. Dynamic queries are appropriate when you want
to vary the structure of the query itself, such as which columns
are selected, which table gets selected from, which columns to test
in the WHERE clause, which columns to order by, etc.; or if you
want to defeat plan caching (e.g., when using temporary tables).
--
Michael Fuhr
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2006-06-12 12:37:31 | Re: Question about stored procedures |
Previous Message | Tom Allison | 2006-06-12 10:25:41 | Re: SQL comments |