[SQL] stored procs in postgresql

[ceremona]

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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings