SOME PL/PGSQL PROBLEMS

From: "datactrl" <quals(at)bigfoot(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: SOME PL/PGSQL PROBLEMS
Date: 2001-03-23 09:10:16
Message-ID: 004f01c0b379$19c48c60$2400a8c0@hnjack
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Alexaki Sofia 2001-03-23 10:59:14 Btree index on varchar
Previous Message pgsql-sql 2001-03-23 07:15:02 trigger output to a file