subject:"\[SQL\] Calling Postgresql Function to delete user data"

Re: [SQL] Calling Postgresql Function to delete user data

2012-02-12 Thread Philip Couling

On 11/02/2012 19:53, Rehan Saleem wrote: > Hi , > I have created this function to remove UserDataAccountid > from both tables > UserAccountDetails and UserAC > CREATE OR REPLACE FUNCTION DeleteUserData(ACDetailsID int[]) > RETURNS void AS $$ > DECLARE _id int; > BEGIN > -- postgresql has no tabl

[SQL] Calling Postgresql Function to delete user data

2012-02-11 Thread Rehan Saleem

Hi , I have created this function to remove UserDataAccountid from both tables UserAccountDetails and UserAC CREATE OR REPLACE FUNCTION DeleteUserData(ACDetailsID int[]) RETURNS void AS $$ DECLARE _id int; BEGIN -- postgresql has no table type, use a int array instead FOR _id IN array_lower(AC