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, althou
> 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 mos
# [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
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 PR
# [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
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
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
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 the
