Problem with SQL stored procedure

From: sid tow <siddy_tow(at)yahoo(dot)com>
To: Postgres SQL language list <pgsql-sql(at)postgresql(dot)org>
Subject: Problem with SQL stored procedure
Date: 2006-12-08 11:27:59
Message-ID: 20061208112759.12757.qmail@web36703.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all

I dont know if this is the right forum to post this but any way if you could help me or guide me to an appropriate forum, I would appreciate it.
I am trying to call a SQL (SQL server 2000) stored procedure from my c++ code and in that stored procedure I have a Print statement which will print some string. Now the problem is that the parameters that I supply to the stored procedure are returned back with out being modified, but I expect some modifications to happen to those parameters. And if I comment out the Print statement I get what I desire. Can somebody explain what exactly is happening here?

Regards,
Syed

----- Original Message ----
From: ivan marchesini <marchesini(at)unipg(dot)it>
To: Postgres SQL language list <pgsql-sql(at)postgresql(dot)org>
Sent: Monday, November 13, 2006 10:02:06 PM
Subject: [SQL] drop a check

Dear all...
I have created a check constraint without giving it a name..
now I have a check named "$25" in my table that I need to drop or
modify!!!
How can I do???
with names is simple

alter table tablename drop constraint constraintname;

but without name?? :-)

many thanks...

Ivan

--
Ivan Marchesini
Department of Civil and Environmental Engineering
University of Perugia
Via G. Duranti 93/a
06125
Perugia (Italy)
e-mail: marchesini(at)unipg(dot)it
ivan(dot)marchesini(at)gmail(dot)com
tel: +39(0)755853760
fax: +39(0)755853756
jabber: geoivan73(at)jabber(dot)org

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


____________________________________________________________________________________
Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Shoaib Mir 2006-12-08 11:39:05 Re: Problem with SQL stored procedure
Previous Message Tom Lane 2006-12-07 23:42:56 Re: could not find pathkey item to sort