Escaping the $1 parameter in stored procedures - Mailing list pgsql-sql

From limr@yahoo.com (robert)
Subject Escaping the $1 parameter in stored procedures
Date
Msg-id 75f517f5.0310131218.3a2907e5@posting.google.com
Whole thread Raw
List pgsql-sql
I'm running Postgres 7.3.2 in Redhat 9.0.

I'm trying to execute a function below defined as a stored procedure
  ALTER TABLE tms_schedule DROP CONSTRAINT "$1";

However, postgres thinks the "$1" is a parameter value.  How do I tell
postgres to treat it as a literal $1?

TIA,
Robert


pgsql-sql by date:

Previous
From: "Stefan Sturm"
Date:
Subject: Re: [postgres] Foreign Key
Next
From: "Marc G. Fournier"
Date:
Subject: removing precision from timestamp (microseconds) ..