-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
William ZHANG írta: | ""Ivan"" <[EMAIL PROTECTED]> Writes news:[EMAIL PROTECTED] | |>As I am new in the world of PostgreSQL I would like to know what are the |>advantages of using it. | IMHO:
Stored procedures Triggers Views Rules
With them you can embeed your aplications logic right in the database, instead of implementing it on the (database) client application, in this way no mather how you connect to the database, from psql, a webap, or a GUI application you will "see" the same thing. E.g. if for a payment are allowed sums between $100 and $1000 you could prevent inserting other values by defining a trigger. Or if modifying some data in a table should happen when you insert something in an other table, you could write a rule, for it.
Best Regards,
Geza Gemes -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE/wivv/PxuIn+i1pIRAs/iAJ9lEdNe0CfXYw15zLuuLS+LBdkqcgCfQ3cU h9yVsRMWTX7F99zLd/PoV1o= =FP5A -----END PGP SIGNATURE-----
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
