Re: [HACKERS] constraint upon view

2004-06-20 Thread Pierre Emmanuel Gros
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,

[HACKERS] constraint upon view

2004-06-02 Thread Pierre Emmanuel Gros
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 ??? Thank you Pierre

Re: [HACKERS] constraint upon view

2004-06-02 Thread Jonathan Gardner
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