Converting Query from MS SQL

From: "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>
To: "psql" <pgsql-sql(at)postgresql(dot)org>
Subject: Converting Query from MS SQL
Date: 2003-10-06 13:04:45
Message-ID: 017801c38c0a$7e4bbc00$7502a8c0@hdsc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dear Friends,

I am working with Postgres 7.3.4 on RH Linux 7.2. While migrating all the SPs (from MS SQL Server), I come across these lines in MS SQL Server procedure.

SET @v_sql = "UPDATE "Schema1".employee SET rec_deleted_flag = 'Y' WHERE empid IN (" + @p_list_ids + ");"
EXEC(@v_sql)

Actually to dynamically pass the values for the 'IN' the pass the @p_list_ids (a comma separated string ) to the variable @v_sql and then execute it.

How can I change it for postgres?

Thank you very much for ur support

Regards
Kumar

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message teknokrat 2003-10-06 13:28:39 row and column transposition
Previous Message HR 2003-10-06 10:45:32 Bad encoding in URL