Re: What is the advantage

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

William ZHANG írta:
| ""Ivan"" <zenzo(at)net(dot)hr> Writes news:3fbfbbfe(dot)2dd6(dot)0(at)net(dot)hr(dot)(dot)(dot)
|
|>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-----