Francis Waweru wrote:
Am creating a function that will be able to sort date from a table that is over 400,000 rows. I want to pass variables from a java application am running but I can't able to do so. Please help on how to pass a variable from an application to a function so that I can speed up my select queries.
You haven't said what you've tried so far. There's nothing special about passing variables to a function - it's just part of a query.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster