Hi, I have encountered a problem with plpgsql and I would appreciated it if anyone could help me with this.
If I have a relation say: emp_id | salary --------------------------- 1 | 40000.00 --------------------------- 2 | 45600.00 --------------------------- 3 | 40000.00 --------------------------- 4 | 45600.00 --------------------------- 5 | 40000.00 --------------------------- my plpgsql function is to be as the following format: get_emp_ids(float) it takes in the salay amount and returns a list of emp_ids that have the corresponding salary. how should I go about doing it in plpgsql? there's no return type that allows you to return multiple rows. is "raise notice" the only way to display these results? thanks in advance for your help. ps. please also send a cc to me when replying. Bill -- Everything you know is wrong! --------------------------------------------- Bill Shui Email: [EMAIL PROTECTED] Bioinformatics Programmer ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
