On Monday 06 October 2003 14:04, Kumar wrote: > 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?
Something like (in plpgsql): EXECUTE ''UPDATE "Schema1".employee SET ...'' || my_list_var || '')''; See the manuals for more details. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match