Re: PostgreSQL 9.6: view based on sequence

From: Enrico Pirozzi <e(dot)pirozzi(at)nbsgroup(dot)it>
To:
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL 9.6: view based on sequence
Date: 2018-01-24 12:05:06
Message-ID: a74c0eaf-784e-1bf2-e4cd-69eb5fa38f92@nbsgroup.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)pirozzi(at)nbsgroup(dot)it

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincenzo Romano 2018-01-24 12:06:09 Re: PostgreSQL 9.6: view based on sequence
Previous Message Enrico Pirozzi 2018-01-24 12:02:32 Re: PostgreSQL 9.6: view based on sequence