https://forum.postgresql.org.pl/viewtopic.php?id=1427 Wed, 05 Dec 2012 22:42:52 +0000 PunBB https://forum.postgresql.org.pl/viewtopic.php?pid=3832#p3832 Wed, 05 Dec 2012 22:42:52 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3832#p3832 https://forum.postgresql.org.pl/viewtopic.php?pid=3830#p3830 '0']]> Wed, 05 Dec 2012 14:47:39 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3830#p3830 https://forum.postgresql.org.pl/viewtopic.php?pid=3829#p3829 '0' order by czas,id; 2. drop sequence lp; 3. create sequence lp START WITH 1; 4. update z tak zmodyfikowanym selectem (select t.id ,czas+nextval ('lp') * interval '00:01:00' as nowa_data from v_tabela) t where t.id=d.id ; 5. drop sequence lp;]]> Wed, 05 Dec 2012 13:59:29 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3829#p3829 https://forum.postgresql.org.pl/viewtopic.php?pid=3828#p3828 '0'; jak je uruchamiam to mam: LINE 3: ...t.id ,czas from zgloszenie t order by czas,id) z) d where t.... ^ ********** Błąd ********** BŁĄD: błąd składni w lub blisko "d" Stan SQL: 42601 Znak: 134]]> Wed, 05 Dec 2012 13:49:54 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3828#p3828 https://forum.postgresql.org.pl/viewtopic.php?pid=3827#p3827 Wed, 05 Dec 2012 13:46:04 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3827#p3827 https://forum.postgresql.org.pl/viewtopic.php?pid=3826#p3826 Wed, 05 Dec 2012 13:42:14 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3826#p3826 https://forum.postgresql.org.pl/viewtopic.php?pid=3824#p3824 Wed, 05 Dec 2012 08:07:47 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3824#p3824 https://forum.postgresql.org.pl/viewtopic.php?pid=3823#p3823 Tue, 04 Dec 2012 22:07:51 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3823#p3823 https://forum.postgresql.org.pl/viewtopic.php?pid=3822#p3822 Tue, 04 Dec 2012 22:07:02 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3822#p3822 https://forum.postgresql.org.pl/viewtopic.php?pid=3821#p3821 Tue, 04 Dec 2012 21:54:53 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3821#p3821 https://forum.postgresql.org.pl/viewtopic.php?pid=3819#p3819 Tue, 04 Dec 2012 20:06:01 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3819#p3819 https://forum.postgresql.org.pl/viewtopic.php?pid=3818#p3818 Tue, 04 Dec 2012 14:00:45 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3818#p3818