Re: Triggers in Postgres
От
Jasbinder Bali
Тема
Re: Triggers in Postgres
Дата
Msg-id
a47902760607310858j7e968f84ua9e0c5741b2ad7be@mail.gmail.com
Ответ на
Re: Triggers in Postgres (Tino Wildenhain)
Список
Дерево обсуждения
Triggers in Postgres "Jasbinder Bali" <jsbali@gmail.com>
Re: Triggers in Postgres Tino Wildenhain <tino@wildenhain.de>
Re: Triggers in Postgres "Jasbinder Bali" <jsbali@gmail.com>
Re: Triggers in Postgres Roman Neuhauser <neuhauser@sigpipe.cz>
Re: Triggers in Postgres "Jasbinder Bali" <jsbali@gmail.com>
Re: Triggers in Postgres Chris Mair <list@1006.org>
Re: Triggers in Postgres Tom Lane <tgl@sss.pgh.pa.us>
Re: Triggers in Postgres Roman Neuhauser <neuhauser@sigpipe.cz>
Re: Triggers in Postgres Richard Huxton <dev@archonet.com>
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 <tino@wildenhain.de> wrote:
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 written in procedural languages only?
> Please put some insight on what needs to be known before working with
> triggers in postgres.
You should probably try it when you read all manuals :-)
pl/sql is very close to pure SQL, so if you manage to write
your trigger with it - why not? :-)
What should your trigger do btw?
Regards
Tino
В списке pgsql-general по дате отправления
