stored procs in postgresql - Mailing list pgsql-sql

From ceremona@gmail.com
Subject stored procs in postgresql
Date
Msg-id op.sxmghwnc1qrx7c@localhost
Whole thread Raw
List pgsql-sql
Hi,

I have been having some trouble with plsql stored procs in postgres in
that I can
make a table name a variable in the stored proc.  Is there some special
way to make this happen that I am unaware of?

For example, I want to do something like:

stored_proc(integer,varchar)

SELECT table_name.id   FROM table_name $2  WHERE table_name.id=$1

but I get an error about the $2 argument being no good.

Does anyone know how I can deal with this?

Thanks,
Cere



pgsql-sql by date:

Previous
From: Aldor
Date:
Subject: Re: VACUUM FULL vs dump & restore
Next
From: Chris Browne
Date:
Subject: Re: stored procs in postgresql