Re: [GENERAL] Is my MySQL Gaining ?

Tony wrote:

> I already had in the first post I replied to,  but at the risk of 
> sounding redundant, I'll say it again.
>
> Views:  When I came to PG I didn't know what they were, saw no point 
> to them (still don't) why do you need a function to provide details of 
> a query when a more complicated query gives the same data?  Are they 
> designed for people who don't like to type long queries?

They are designed for several things IMHO.

 1. So I don't have to type long queries.
 2. So I can have a base query and just append where clauses, joins 
etc... as I need.
 3. So I can provide permissions based on the view, not the table itself 
-- thus lending to a more flexible acl model.

Sincerely,

Joshua D. Drake


-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC - S/JDBC
Postgresql support, programming, shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com