Thread: Using $n in a select statement in PL/pgSQL

I can't find very many references to PL/pgSQL. Can anyone point me to lots
of examples? In particular, select statements don't appear to like the $n
variables, unless I'm just doing something really wrong.

I can post an example of what I'm doing if necessary, but right now I'd
really just like to find some references to the language.

Cheers,
Jim

Jim Cain wrote:

> I can't find very many references to PL/pgSQL. Can anyone point me to lots
> of examples? In particular, select statements don't appear to like the $n
> variables, unless I'm just doing something really wrong.
>

Try the regression tests in .../src/test/regress/sql/plpgsql....

Cheers,
Ed Loehr