# [EMAIL PROTECTED] / 2006-07-31 11:58:49 -0400:
Actually Postgres manual of triggers says that in postgres, you can't write
a trigger in conventional sql. You have to write it in a procedural language
like C. So wanted some more insight on it.
~Jas
Where does it say so? Do you have a
http://www.postgresql.org/docs/8.1/interactive/triggers.html
it says something like this:
It is not currently possible to write a trigger function in the plain SQL function language.
though lately I saw triggers written in pure sql in postgres
~jas
On 8/1/06, Roman Neuhauser [EMAIL
# [EMAIL PROTECTED] / 2006-08-01 02:35:48 -0400:
On 8/1/06, Roman Neuhauser [EMAIL PROTECTED] wrote:
# [EMAIL PROTECTED] / 2006-07-31 11:58:49 -0400:
Actually Postgres manual of triggers says that in postgres, you can't
write
a trigger in conventional sql. You have to write it in a
http://www.postgresql.org/docs/8.1/interactive/triggers.html
it says something like this:
It is not currently possible to write a trigger function in the
plain SQL function language.
The whole paragraph says.
It is also possible to write a trigger function in C, although most
people
Chris Mair [EMAIL PROTECTED] writes:
http://www.postgresql.org/docs/8.1/interactive/triggers.html
It is not currently possible to write a trigger function in the
plain SQL function language.
The whole paragraph says.
It is also possible to write a trigger function in C, although most
Hi,Was wondering if one can write triggers with SQL statements as we have in other RDBMS like SQL Server and oracle. Can these be written in procedural languages only?Please put some insight on what needs to be known before working with triggers in postgres.
I've already read the postgres manual
Jasbinder Bali wrote:
Hi,
Was wondering if one can write triggers with SQL statements as we have
in other RDBMS like SQL Server and oracle.
What would such a trigger in SQL statements look like?
SQL Server has Triggers in Transact-SQL, which is just something
like a pl/language.
Can these be
Actually Postgres manual of triggers says that in postgres, you can't write a trigger in conventional sql. You have to write it in a procedural language like C. So wanted some more insight on it.
~Jas
On 7/31/06, Tino Wildenhain [EMAIL PROTECTED] wrote:
Jasbinder Bali wrote: Hi, Was wondering if
Jasbinder Bali wrote:
Actually Postgres manual of triggers says that in postgres, you can't
write a trigger in conventional sql. You have to write it in a
procedural language like C. So wanted some more insight on it.
See chapters 35 - 39 of the manual for details. In particular a
discussion