Sally Sally wrote:
> existing unique field will have to be a character of fixed length
> (VARCHAR(12)) because although it's a numeric value there will be
> leading zeroes.
Plenty of people are contributing their tuppence-worth regarding the
choice of surrogate vs natural primary key.
Can I just point out that your existing unique field is EITHER a numeric
value OR it has a fixed number of characters - numbers don't have
If what you have is a number, then perhaps consider int8/numeric types
and format appropriately when you display the values.
In response to
pgsql-general by date
|Next:||From: Martijn van Oosterhout||Date: 2004-10-27 08:26:56|
|Subject: Re: Bug or stupidity|
|Previous:||From: Thomas Hallgren||Date: 2004-10-27 07:43:36|
|Subject: Re: Theory|