Re: Question about stored procedures

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