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