Re: Dumb Character Column
Date: Wed, 27 Jan 2010 20:33:37 +0100
On 27.01.2010 17:31, The Magnet wrote:
> We are on Oracle 10g. My solution was that of above. Do a function
> that returns a 1 or 0 and query based on that:
If you only need numbers and there is a significant amount of non numbers you could also return NULL for non numbers in order to keep the index small.
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Wed Jan 27 2010 - 13:33:37 CST