Hi there, Could someone please tell me why the following query won't work
select DISTINCT get_unit(unit) as unit, get_ingredient(ing) as ing, get_ing_aisle(1,ing) as aisle from recipe_ing where recipe in(1084, 1086, 1012, 618) and qtydec>0 and ing not in(select ing from excluded_ing where owner=1) order by aisle the query returns the following with no values for aisle, but there should be some. "c";"Pumpkin Seeds";"" "tb";"Horseradish";"" "c";"Puffed Quinoa";"" "c";"Honey";"" "c";"sesame seeds";"" "";"Red Onion";"" "ts";"Spicy Mustard";"" "c";"Dry Oatmeal";"" "c";"Ketchup";"" "ts";"Pepper";"" "tb";"Brown Sugar";"" "c";"Pecans";"" "ts";"Dijon Mustard";"" "single";"Cadbury Flake Bar";"" "g";"Caster Sugar";"" "g";"Low-fat Mozzarella Cheese";"" "md";"Onion";"" "sm";"Whole-wheat Pita";"" "medium";"Lemon";"" "c";"Raisins";"" "c";"Almonds";"" "c";"Dates";"" "g";"Ham";"" "lb";"Ground Sirloin";"" "c";"Shredded Coconut";"" "c";"Sunflower Seeds";"" "";"Tomato";"" The function used to extract aisle is CREATE OR REPLACE FUNCTION get_ing_aisle(bigint, bigint) RETURNS character AS 'SELECT get_aisle(aisle) as aisle FROM ingredient_owner WHERE ingredient=$1 and owner=$2' LANGUAGE 'sql' VOLATILE COST 100; Cheers Barb