[SQL] SOME PL/PGSQL PROBLEMS

[datactrl]

I found there are some problems with PL/pgSQL.
1) 'Drop Table' doesn't work at all
2) '--' comment causes parsing error
3) Execute doesn't work at all. It always causes parsing error!

Some questions
1) Can I use variable in FROM clause for a table name?
2) Can I use variable in WHERE such as xxx = variable?

JACK




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl