https://forum.postgresql.org.pl/viewtopic.php?id=131 Fri, 07 Aug 2009 19:16:24 +0000 PunBB https://forum.postgresql.org.pl/viewtopic.php?pid=1134#p1134 Fri, 07 Aug 2009 19:16:24 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=1134#p1134 https://forum.postgresql.org.pl/viewtopic.php?pid=1132#p1132 Fri, 07 Aug 2009 10:36:12 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=1132#p1132 https://forum.postgresql.org.pl/viewtopic.php?pid=529#p529 Szybki przykładzik, może się przyda. [code],-[19:42:22]merlin@[local]:5432= `-merlin>create TEMP sequence test_seq; ,-[19:42:24]merlin@[local]:5432 `-merlin=>select a.*, nextval('test_seq') as rownum from bigtable a order by 1 asc LIMIT 10; id | pole1 | rownum ----+-------+-------- 1 | 971 | 1 2 | 1447 | 2 3 | 3150 | 3 4 | 3553 | 4 5 | 4654 | 5 6 | 4882 | 6 7 | 5121 | 7 8 | 5128 | 8 9 | 6389 | 9 10 | 7903 | 10 (10 rows)[/code]]]> Fri, 06 Feb 2009 18:47:17 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=529#p529 https://forum.postgresql.org.pl/viewtopic.php?pid=481#p481 Fri, 30 Jan 2009 09:09:50 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=481#p481 https://forum.postgresql.org.pl/viewtopic.php?pid=478#p478 Wed, 28 Jan 2009 21:54:04 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=478#p478 https://forum.postgresql.org.pl/viewtopic.php?pid=477#p477 Wed, 28 Jan 2009 19:09:21 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=477#p477 https://forum.postgresql.org.pl/viewtopic.php?pid=476#p476 Wed, 28 Jan 2009 07:57:20 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=476#p476