-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/09/07 03:48, Ashish Karalkar wrote: > Ok. That is on insert update delete part. > ant disadvantage on select part? Performance-wise? No. Both an advantage and disadvantage of views is that it codifies certain queries in the database. P.S. - top-posting is rude. > ----- Original Message ----- From: "Ron Johnson" <ron.l.johnson@xxxxxxx> > To: <pgsql-general@xxxxxxxxxxxxxx> > Sent: Wednesday, May 09, 2007 2:18 PM > Subject: Re: [GENERAL] Views- Advantages and Disadvantages > > > On 05/09/07 03:36, Ashish Karalkar wrote: >>>> Thanks All for your replies, >>>> But then dont we have any disadvantage of using View??? > > You can't insert into multi-table views. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGQY5QS9HxQb37XmcRAmgZAJ9LiKaJHwsPlTnZi9UpbiqEANpfdACaAqeS KtJSyTH7FcWp4JOna9BqNkc= =EBCc -----END PGP SIGNATURE-----