Subject Re: [firebird-support] Computed column for primary key
Author Gordon Niessen
On 6/9/2011 3:29 AM, Alan J Davies wrote:
> If every record has this character "-", it becomes meaningless in an
> index. All you need is this:
This might not be true in all cases. Take for example the following
data set:
DEPT_ID BUILD_ID ACCOUNT_NBR
1 1 1-1
1 21 1-21
12 1 12-1

Separators can be important.
--

Thanks,

Gordon