https://forum.postgresql.org.pl/viewtopic.php?id=138 Sat, 07 Feb 2009 08:07:07 +0000 PunBB https://forum.postgresql.org.pl/viewtopic.php?pid=535#p535 Sat, 07 Feb 2009 08:07:07 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=535#p535 https://forum.postgresql.org.pl/viewtopic.php?pid=534#p534 Fri, 06 Feb 2009 22:01:01 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=534#p534 https://forum.postgresql.org.pl/viewtopic.php?pid=533#p533 Fri, 06 Feb 2009 20:47:14 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=533#p533 https://forum.postgresql.org.pl/viewtopic.php?pid=532#p532 Fri, 06 Feb 2009 20:10:08 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=532#p532 https://forum.postgresql.org.pl/viewtopic.php?pid=530#p530 create table student (id serial primary key, imienazwisko varchar(30)); NOTICE: CREATE TABLE will create implicit sequence "student_id_seq" for serial column "student.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "student_pkey" for table "student" CREATE TABLE Time: 75,232 ms ,-[19:58:55]merlin@[local]:5432= `-merlin>create table przedmioty(id serial, przedmiot varchar(16)); NOTICE: CREATE TABLE will create implicit sequence "przedmioty_id_seq" for serial column "przedmioty.id" CREATE TABLE Time: 3,948 ms ,-[19:59:15]merlin@[local]:5432= `-merlin>create table oceny(id_studenta int, id_przedmiotu int, ocena numeric(4,2)); CREATE TABLE Time: 4,204 ms ,-[19:59:52]merlin@[local]:5432= `-merlin>insert into student(imienazwisko) values('ja'),('ty'),('inni'),('cizli'); INSERT 0 4 Time: 362,522 ms ,-[20:00:36]merlin@[local]:5432= `-merlin>insert into przedmioty(przedmiot) values('sieci'),('analiza'),('fiza'),('matma'); INSERT 0 4 Time: 1,396 ms ,-[20:01:15]merlin@[local]:5432= `-merlin>insert into oceny values(1,1,2.0); INSERT 0 1 Time: 1,191 ms ,-[20:01:44]merlin@[local]:5432= `-merlin>insert into oceny values(1,2,4.0); INSERT 0 1 Time: 0,870 ms ,-[20:01:48]merlin@[local]:5432= `-merlin>insert into oceny values(3,4,6.0); INSERT 0 1 Time: 0,951 ms ,-[20:01:58]merlin@[local]:5432= `-merlin>select s.imienazwisko as student, p.przedmiot, c.ocena from student s, oceny c, przedmioty p where s.id=c.id_studenta and c.id_przedmiotu=p.id; student | przedmiot | ocena ---------+-----------+------- ja | sieci | 2.00 ja | analiza | 4.00 inni | matma | 6.00 (3 rows) Time: 1,250 ms[/code] Pomijam fakt FK, Unique itp ;] I troche nie wiem po co kobinowac ... Po co sobie zycie utrudniac :P]]> Fri, 06 Feb 2009 19:05:46 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=530#p530 https://forum.postgresql.org.pl/viewtopic.php?pid=528#p528 Fri, 06 Feb 2009 16:52:45 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=528#p528 https://forum.postgresql.org.pl/viewtopic.php?pid=526#p526 Fri, 06 Feb 2009 07:19:16 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=526#p526 https://forum.postgresql.org.pl/viewtopic.php?pid=525#p525 Thu, 05 Feb 2009 19:24:52 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=525#p525 https://forum.postgresql.org.pl/viewtopic.php?pid=524#p524 Wed, 04 Feb 2009 21:46:36 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=524#p524 https://forum.postgresql.org.pl/viewtopic.php?pid=523#p523 Wed, 04 Feb 2009 21:25:04 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=523#p523 https://forum.postgresql.org.pl/viewtopic.php?pid=522#p522 Wed, 04 Feb 2009 18:36:15 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=522#p522