Escaping the $1 parameter in stored procedures

From: limr(at)yahoo(dot)com (robert)
To: pgsql-sql(at)postgresql(dot)org
Subject: Escaping the $1 parameter in stored procedures
Date: 2003-10-13 20:18:10
Message-ID: 75f517f5.0310131218.3a2907e5@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message 2000info 2003-10-13 20:27:40 SSL
Previous Message Ian Barwick 2003-10-13 17:15:21 Re: [postgres] Antwort von Microsoft auf Mail hier!