Re: add constraints to views - Mailing list pgsql-general

Andreas Fromm wrote:

> CREATE VIEW test_view (
> ~    SELECT * FROM test_table WHERE tag
> );
>
> Now I want ad a NOT NULL constraint to the view on field1. I tryed the
> following, but neither works.

what does mean add a null constrain to a view ?  Do you mean
filter out the records with the field1 null ?

CREATE OR REPLACE test_view AS
     SELECT *
     FROM test_table
     WHERE field1 IS NOT NULL AND
           tag;


Regards
Gaetano Mendola