In response to Khin, Gerald :
> The following SQL leads to a unique constraint violation error message
You have already got the answer ... for the same question from you.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006
The following SQL leads to a unique constraint violation error message
(PostgreSQL 8.4.1).
create table test (val integer);
create unique index test_uni on test(val);
insert into test (val) values (1);
insert into test (val) values (2);
insert into test (val) values (3);
update
In response to Khin, Gerald :
> The following SQL leads to a unique constraint violation error message
> (PostgreSQL 8.4.1).
>
>
>
>
>
> create table test (val integer);
>
>
>
> create unique index test_uni on test(val);
>
>
>
> insert into test (val) values (1);
>
> insert into tes
The following SQL leads to a unique constraint violation error message
(PostgreSQL 8.4.1).
create table test (val integer);
create unique index test_uni on test(val);
insert into test (val) values (1);
insert into test (val) values (2);
insert into test (val) values (3);
update