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