Re: Pass multiple numeric values to a function

From: Greg Rahn <>
Date: Thu, 12 Feb 2009 17:47:47 -0800
Message-ID: <>

On Thu, Feb 12, 2009 at 11:29 AM, Ravi Gaur <> wrote:
> One of our developers is trying to write a function that accepts multiple
> values (all numbers) that he can use inside the IN clause of the query.

Sometimes a question is the best first response... Why does this developer want to approach the problem this way?

Not knowing what the problem is at hand, an alternative suggestion would be to use a table function so a join could be used instead of a variable length IN list.

Greg Rahn
Received on Thu Feb 12 2009 - 19:47:47 CST

Original text of this message