Re: AW: [HACKERS] New SQL Datatype RECURRINGCHAR

2001-07-09 Thread Peter Eisentraut
Tom Lane writes: > SQL92 gives this restriction on WHERE clauses for updatable views: > > d) If the immediately contained in QS imme- > diately contains a WC, then no leaf generally > underlying table of QS shall be a generally underlying table >

Re: AW: [HACKERS] New SQL Datatype RECURRINGCHAR

2001-07-09 Thread Jan Wieck
Tom Lane wrote: > Hannu Krosing <[EMAIL PROTECTED]> writes: > > Zeugswetter Andreas SB wrote: > >> The most prominent of the "interesting uses" probably beeing when the views > >> are part of the authorization system, since views are the only standardized > >> mechanism to restrict access at the r

Re: AW: [HACKERS] New SQL Datatype RECURRINGCHAR

2001-07-09 Thread Tom Lane
Hannu Krosing <[EMAIL PROTECTED]> writes: > Zeugswetter Andreas SB wrote: >> The most prominent of the "interesting uses" probably beeing when the views >> are part of the authorization system, since views are the only standardized >> mechanism to restrict access at the row level. > True, and oft

Re: AW: [HACKERS] New SQL Datatype RECURRINGCHAR

2001-07-09 Thread Hannu Krosing
Zeugswetter Andreas SB wrote: > > > > My feeling is that the restrictions are stringent enough to eliminate > > most of the interesting uses of views, and hence an automatic rule > > creation feature is not nearly as useful/important as it appears at > > first glance. > > The most prominent of

AW: [HACKERS] New SQL Datatype RECURRINGCHAR

2001-07-09 Thread Zeugswetter Andreas SB
> My feeling is that the restrictions are stringent enough to eliminate > most of the interesting uses of views, and hence an automatic rule > creation feature is not nearly as useful/important as it appears at > first glance. The most prominent of the "interesting uses" probably beeing when th