Re: [PERFORM] Query involving views

2004-06-06 Thread Laurent Martelli
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes: Tom> Laurent Martelli <[EMAIL PROTECTED]> writes: >> Now, if I use the following view to abstract access rights: >> CREATE VIEW userpictures ( >> PictureID,RollID,FrameID,Description,Filename, >> Owner,EntryDate,Date, >> NbClick,NbRa

Re: [PERFORM] Query involving views

2004-06-06 Thread Tom Lane
Laurent Martelli <[EMAIL PROTECTED]> writes: > Now, if I use the following view to abstract access rights: > CREATE VIEW userpictures ( >PictureID,RollID,FrameID,Description,Filename, >Owner,EntryDate,Date, >NbClick,NbRates,MaxRate,MinRate,AverageRate,SumRates, >Use

[PERFORM] Query involving views

2004-06-06 Thread Laurent Martelli
Hello again, This question is related to my previous one (Unused table of view, see http://archives.postgresql.org/pgsql-performance/2004-06/msg00043.php). For the moment, I have queries where I join tables by hand. Since a few tables are always joined together, I thought I could define a view to