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