Help : Update and insert record based on several value in the parameter

2019-01-29 Thread Hengky Lie
Hi, I want to create a function to update my table (flag='9') and insert new record (flag='0') with the rfidnumber specified in a parameter. This parameter may have several value seperated by space (ie. 11 22 33 44) CREATE OR REPLACE FUNCTION public.fcreate_rfid ( znumber varchar ) RETURNS boo

Help : Update and insert record based on several value in the parameter

2019-01-29 Thread Hengky Lie
Hi, I want to create a function to update my table (flag='9') and insert new record (flag='0') with the rfidnumber specified in a parameter. This parameter may have several value seperated by space (ie. 11 22 33 44) CREATE OR REPLACE FUNCTION public.fcreate_rfid ( znumber varchar ) RETURNS boo