
Choosing a Column Depending on Procedure Argument
Question: Can I specify the column I want to select from as an argument to the procedure? Something like: create procedure show_product(language char(2), ID integer) returning char(255);define p_prod_name CHAR (255);select language INTO p_prod_name from productnames where prod_id = ID;return p_prod_name;END PROCEDURE The table productnames would then contain a column for