<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_rule.sgml,v 1.16 2000/05/20 11:38:25 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_rule.sgml,v 1.17 2000/07/21 04:22:54 momjian Exp $

Postgres documentation

-->

</programlisting>

</para>

<para>

Create a view of the employees working in the toy department.

Create a view of the employees working in the toy department:

<programlisting>

CREATE toyemp(name = char16, salary = int4);

</programlisting>

</para>

<para>

All new employees must make 5,000 or less

All new employees must make 5,000 or less:

<programlisting>

CREATE RULE example_5 AS

ON INERT TO emp WHERE new.salary > 5000

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.12 2000/05/08 16:19:56 thomas Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.13 2000/07/21 04:25:05 momjian Exp $

Postgres documentation

-->

CREATE SEQUENCE serial START 101;

</programlisting>

<para>

Select the next number from this sequence

Select the next number from this sequence:

<programlisting>

SELECT NEXTVAL ('serial');