| From: | elein(at)varlena(dot)com (elein) |
|---|---|
| To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: UPDATEABLE VIEWS ... Examples? |
| Date: | 2005-06-17 01:04:52 |
| Message-ID: | 20050617010452.GE30133@varlena.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
There is a write up on these at:
http://www.varlena.com/GeneralBits/82.php
--elein
============================================================
elein(at)varlena(dot)com Varlena, LLC www.varlena.com
PostgreSQL Consulting, Support & Training
PostgreSQL General Bits http://www.varlena.com/GeneralBits/
=============================================================
I have always depended on the [QA] of strangers.
On Thu, Jun 16, 2005 at 06:05:03PM -0300, Marc G. Fournier wrote:
>
> Reading through the docs, both the CREATE VIEW and CREATE RULE pages refer
> to how you can use a RULE to 'simulate' an updateable VIEW ... but I can't
> seem to find any examples of this ...
>
> Does anyone know of an online example of doing this that I can read
> through?
>
> Thanks ...
>
> ----
> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitri Bichko | 2005-06-17 01:33:42 | Re: UPDATEABLE VIEWS ... Examples? |
| Previous Message | Din Adrian | 2005-06-16 23:38:53 | Re: [SQL] PostgreSQL and Delphi 6 |