Re: View consistency

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

"David M. Richter" <d(dot)richter(at)dkfz-heidelberg(dot)de> writes:
> Select name from patient_view;
> is in reality:
> Select name from (select ...,...,... from basic where xxx=yyy);
> Is that right?

Yup. The rule rewriter just substitutes the view definition as a
subselect.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Orion 2001-11-02 23:15:36 Help with a complex Update
Previous Message David M. Richter 2001-11-02 08:45:35 Re: View consistency