Re: PostgreSQL 9.6: view based on sequence - Mailing list pgsql-general

From Enrico Pirozzi
Subject Re: PostgreSQL 9.6: view based on sequence
Date
Msg-id a74c0eaf-784e-1bf2-e4cd-69eb5fa38f92@nbsgroup.it
Whole thread Raw
In response to Re: PostgreSQL 9.6: view based on sequence  (Vincenzo Romano <vincenzo.romano@notorand.it>)
List pgsql-general
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@nbsgroup.it



pgsql-general by date:

Previous
From: Enrico Pirozzi
Date:
Subject: Re: PostgreSQL 9.6: view based on sequence
Next
From: Vincenzo Romano
Date:
Subject: Re: PostgreSQL 9.6: view based on sequence