Thanks for the answers. They really helped me.
As I thougth, that is sort of issue related
to modeling, design, RDBMS and experience!
> Rafael Charnovscki <charnovs(at)unesc(dot)rct-sc(dot)br> writes:
>>I have a 6-digit integer number for a patient identifier which
>>I intend to use as a primary key (PK) for a table. It also will
>>be a foreign key in other tables. Do I have to use an integer data
>>type as a domain for this PK or could I use a varchar(6)?
In response to
pgsql-novice by date
|Next:||From: Betsy Barker||Date: 2004-07-28 21:02:24|
|Subject: Problem assigning return value from function to a variable|
|Previous:||From: Chris||Date: 2004-07-27 07:29:32|
|Subject: Re: hexdecimal constant in postgresql|