Re: Dumb Character Column
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Wed, 27 Jan 2010 20:33:37 +0100
Message-ID: <7sbiooF5ovU1_at_mid.individual.net>
On 27.01.2010 17:31, The Magnet wrote:
Date: Wed, 27 Jan 2010 20:33:37 +0100
Message-ID: <7sbiooF5ovU1_at_mid.individual.net>
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.
Cheers
robert
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Wed Jan 27 2010 - 13:33:37 CST