On 9/20/06, CN <[EMAIL PROTECTED]> wrote:
Hi!CREATE TABLE x1 (name TEXT, hobby TEXT, PRIMARY KEY(name,hobby));INSERT INTO x1 VALUES('John','music');INSERT INTO x1 VALUES('John','arts');INSERT INTO x1 VALUES('Bob','arts');INSERT INTO x1 VALUES('Bob','music');
INSERT INTO x1 VALUES('Rocky','copmputer
In article <[EMAIL PROTECTED]>,
"CN" <[EMAIL PROTECTED]> writes:
> select * from x1;
> name | hobby
> ---+--
> John | music
> John | arts
> Bob | arts
> Bob | music
> Rocky | computer
> Steve | arts
> Steve | football
> Tom | computer
> Tom | music
> (9 rows)
Hi!
CREATE TABLE x1 (name TEXT, hobby TEXT, PRIMARY KEY(name,hobby));
INSERT INTO x1 VALUES('John','music');
INSERT INTO x1 VALUES('John','arts');
INSERT INTO x1 VALUES('Bob','arts');
INSERT INTO x1 VALUES('Bob','music');
INSERT INTO x1 VALUES('Rocky','copmputer');
INSERT INTO x1 VALUES('Steve','
