Re: PostgreSQL 9.6: view based on sequence

2018-01-24 13:02 GMT+01:00 Enrico Pirozzi <e(dot)pirozzi(at)nbsgroup(dot)it>:
>
>> 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 appens on a 10.x version :)
>
> Ciao
> --
>
> Enrico Pirozzi
> e(dot)pirozzi(at)nbsgroup(dot)it
>

I haven't any v9 any more in my deployments. Sorry.

What is the objective of that view?
If it's to hide the nextval() function, then the solution can be
similar to mine.
If it's to access the sequence metainfo, then maybe it'd be better to
explore the pg_catalog schema.

--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS