https://forum.postgresql.org.pl/viewtopic.php?id=48 Mon, 09 Jun 2008 10:55:32 +0000 PunBB https://forum.postgresql.org.pl/viewtopic.php?pid=173#p173 Mon, 09 Jun 2008 10:55:32 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=173#p173 https://forum.postgresql.org.pl/viewtopic.php?pid=172#p172 select * from t1; i | c1 | c2 ---+----+---- 1 | a | A 2 | b | B 3 | c | C (3 rows) >select * from t2; i | c1 | c2 ---+------+------ 1 | null | null 2 | null | null 4 | null | null (3 rows)[/code] To po wykonaniu nastepujacego update [code]>update t2 set c1=t1.c1,c2=t1.c2 from t1 where t1.i=t2.i; Time: 11,393 ms (rski@[local]:5432) 12:50:33 [rski][/code] mamy [code]>select * from t2; i | c1 | c2 ---+------+------ 4 | null | null 1 | a | A 2 | b | B (3 rows)[/code] o to chodzilo, update moze miec klauzule FROM.]]> Mon, 09 Jun 2008 10:51:48 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=172#p172 https://forum.postgresql.org.pl/viewtopic.php?pid=170#p170 Mon, 09 Jun 2008 09:37:51 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=170#p170