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

In fact i want this kind of view , because my views are forms with a
jdbc selection like

create view toto (integer,integer) as SELECT a,b FROM executeJDBC(jdbc
connection,jdbc uri, 'select a,b from toto');

Where the view toto is filled by the function executeJDBC (jdbc driver,
jdbc uri, remote query )

The problem is i lose to much information about my remote table (primary
key, indexes...) to make good JOIN operation.(for big table , this join
operation
without information upon primary key are very slow...)

So i like to extends the create view syntax to add constraint
information , and i hope speed up my join operation.

I would like to know what to change in the source to obtain this extension .
Pierre
PS excuse me if i was not clear.

Jonathan Gardner wrote: