SOME PL/PGSQL PROBLEMS - Mailing list pgsql-sql

From datactrl
Subject SOME PL/PGSQL PROBLEMS
Date
Msg-id 004f01c0b379$19c48c60$2400a8c0@hnjack
Whole thread Raw
Responses Re: SOME PL/PGSQL PROBLEMS  (Richard H <dev@archonet.com>)
Re: SOME PL/PGSQL PROBLEMS  (Jie Liang <jliang@ipinc.com>)
List pgsql-sql
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





pgsql-sql by date:

Previous
From: "pgsql-sql"
Date:
Subject: trigger output to a file
Next
From: Alexaki Sofia
Date:
Subject: Btree index on varchar