Re: View consistency

From: "David M(dot) Richter" <d(dot)richter(at)dkfz-heidelberg(dot)de>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org
Subject: Re: View consistency
Date: 2001-11-02 08:45:35
Message-ID: 3BE25D2F.9BF837EB@dkfz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

So every time when I 'll use the view, the constraint over the basic
table will be revalidated.

Select name from patient_view;

is in reality:

Select name from (select ...,...,... from basic where xxx=yyy);

Is that right?

DAvid

Attachment Content-Type Size
d.richter.vcf text/x-vcard 498 bytes

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-11-02 15:23:37 Re: View consistency
Previous Message Jason Kwok 2001-11-02 06:58:24 select from a dynamic table name