Search Postgresql Archives

Re: PostgreSQL 9.6: view based on sequence

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



tmp1=# create sequence x;
CREATE SEQUENCE
Time: 69,857 ms
tmp1=# select * from x;
last_value | log_cnt | is_called
------------+---------+-----------
          1 |       0 | f
(1 row)

Maybe what you want to do is

create view v_test_sequence as select nextval( 'test_sequence' );

Ciao.

Yes but this happens on a 10.x version on a 9.6 version things are differents

Ciao
Enrico

--
Enrico Pirozzi
e.pirozzi@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux