Re: constraint upon view

On Monday 31 May 2004 06:38 am, Pierre Emmanuel Gros wrote:
> Hi,
> I would like to know if i can add constraint and typed column upon a
> create view sentence.
> something like create view toto (a INTEGER primary key , b VARCHAR) as
> select .....
> If it is not possible , what to have to change in the backend sources to
> obtain the result ???
>

I don't think you want a view in this case. When you select against a view, 
the view is unrolled into the statement that forms it. Try a look at the 
results of "EXPLAIN ANALYZE" when you are selecting against a view.

-- 
Jonathan Gardner
jgardner@jonathangardner.net