I guess you could say the [2] is discarded since the value "2" is at the top
or beyond the top of the range.
Achilleas Mantzios wrote:
>
> Στις Παρασκευή 16 Φεβρουάριος 2007 20:35, ο/η chrisj έγραψε:
>> I am quite sure the [2] is not discarded, easy enough to test but I don't
>> have access to P
Hi list,
Could someone help me with this problem
I have a table like this
Master table
id number
10 9898398398
20 9938378390
30 9873636736
and I want to make an insert into a table with this structure:
Secondary table
id(sequence), master_id
110
220
3
Hi lists,
Is there possible to change a bigint field (primary key) to a serial ?
If yes how it is possible ?
I was trying to do that but the pgadmin don't enable the change to sequence.
What is the problem my friends ?
Regards
Ezequias
http://ezequiasrocha.blogspot.com/
--
INSERT INTO second_table (master_id) SELECT id FROM master_table ORDER
BY id;
Was it important to you that the id and master id in the second table
match up? ie, 1 and 10, 2 and 20, 3 and 30 - not 1 and 30, 2 and 10, 3
and 20 etc...
~p
On Sat, 2007-02-24 at 21:06 -0300, Ezequias Rodrigues da Roc
On 2/24/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
Hi lists,
Is there possible to change a bigint field (primary key) to a serial ?
If yes how it is possible ?
I was trying to do that but the pgadmin don't enable the change to sequence.
What is the problem my friends ?
Regards
