| From: | Jonathan Gardner <jgardner(at)jonathangardner(dot)net> |
|---|---|
| To: | Pierre Emmanuel Gros <Pierre-Emmanuel(dot)Gros(at)limsi(dot)fr> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: constraint upon view |
| Date: | 2004-06-02 20:28:46 |
| Message-ID: | 200406021328.46902.jgardner@jonathangardner.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)jonathangardner(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-06-02 20:40:05 | Re: [HACKERS] Configuration patch |
| Previous Message | Marty Scholes | 2004-06-02 19:38:47 | Indices pinned in pageable RAM? |