[SQL] unsubscribe pgsql-sql@postgreSQL.org

2003-07-29 Thread Subramaniam, Sankari (Cognizant)
unsubscribe [EMAIL PROTECTED] This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of t

Re: [SQL] pgsql-sql@postgresql.org

2002-08-14 Thread philip johnson
thanks very much -Message d'origine- De : Stephan Szabo [mailto:[EMAIL PROTECTED]] Envoye : mercredi 14 aout 2002 16:36 A : philip johnson Cc : [EMAIL PROTECTED] Objet : Re: [SQL] [EMAIL PROTECTED] On Wed, 14 Aug 2002, philip johnson wrote: > I've a stored procedure I'd like to migrate

Re: [SQL] pgsql-sql@postgresql.org

2002-08-14 Thread Stephan Szabo
On Wed, 14 Aug 2002, philip johnson wrote: > I've a stored procedure I'd like to migrate from MS SqlServer > to Postgresql 7.2.1. How can I do ? > here is the stored procedure > CREATE PROCEDURE ws_doc_tree_new > @parent_node_id int, > @label varchar(50), > @publication varchar(32) Here, y

Re: [SQL] pgsql-sql@postgresql.org

2002-08-14 Thread philip johnson
because I'm a new to stored procedure I gave only one store procedure, and I've 10 more to convert an example would help me -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]De la part de Christopher Kings-Lynne Envoyé : mercredi 14 août 2002 10:43 À : philip johnson; [

Re: [SQL] pgsql-sql@postgresql.org

2002-08-14 Thread Christopher Kings-Lynne
Why not spend 5 minutes reading the documentation and trying to do it yourself before asking us to do your job for you? http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/plpgsql.html Chris > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of

[SQL] pgsql-sql@postgresql.org

2002-08-14 Thread philip johnson
I've a stored procedure I'd like to migrate from MS SqlServer to Postgresql 7.2.1. How can I do ? here is the stored procedure CREATE PROCEDURE ws_doc_tree_new @parent_node_id int, @label varchar(50), @publication varchar(32) AS DECLARE @doc_exists int, @new_node_id int, @pare