Re: [GENERAL] function depend on view

2012-08-20 Thread Merlin Moncure
On Mon, Aug 20, 2012 at 9:59 AM, Andreas Kretschmer wrote: > salah jubeh wrote: > >> Hello Andreas, >> >> Thanks for the reply, The example I have posted is very simple and you are >> right it is very similar to select max (id) from table_that_does_not_exist; >> But >> there are more here, for

Re: [GENERAL] function depend on view

2012-08-20 Thread Andreas Kretschmer
salah jubeh wrote: > Hello Andreas, > > Thanks for the reply, The example I have posted is very simple and you are > right it is very similar to select max (id) from table_that_does_not_exist; > But > there are more here, for example imagine I have something like > > CREATE VIEW a4 as select

Re: [GENERAL] function depend on view

2012-08-20 Thread Merlin Moncure
On Mon, Aug 20, 2012 at 9:37 AM, salah jubeh wrote: > Hello Andreas, > > Thanks for the reply, The example I have posted is very simple and you are > right it is very similar to select max (id) from table_that_does_not_exist; > But there are more here, for example imagine I have something like >

Re: [GENERAL] function depend on view

2012-08-20 Thread salah jubeh
:47 PM Subject: Re: [GENERAL] function depend on view salah jubeh wrote: > Hello Guys, > > I am having a scenario close to the one below, I have defined a function which > depends on a view. I am able to drop the view, but my server did not complain > about the dependency. >

Re: [GENERAL] function depend on view

2012-08-20 Thread Andreas Kretschmer
salah jubeh wrote: > Hello Guys, > > I am having a scenario close to the one below, I have defined a function which > depends on a view. I am able to drop the view, but my server did not complain > about the dependency. > > In the scenario below, one can drop the views a2 and a1 respectively,