[Pgsql-ayuda] triggers...if UPDATE(nombre_campo) then....

[sandrigo lezcano]

en los triggers en sybase podes
  usar una expresion del tipo:
  ...if UPDATE(nombre_campo) then....
   como ?? 
   podria interpretar esto 
   en PostgreSQL ???

* * * * * del manual del sybase: * * * * *

CREATE TRIGGER statement [T-SQL]
---------------------------------------------------

Description
Use this statement to create a new trigger in the 
database in a manner compatible with Adaptive 
Server Enterprise.

Syntax 1
CREATE TRIGGER [owner.]trigger_name
ON [owner.]table_name
FOR { INSERT, UPDATE, DELETE }
AS statement-list

Syntax 2
CREATE TRIGGER [owner.]trigger_name
ON [owner.]table_name
FOR {INSERT, UPDATE}
AS
[ IF UPDATE ( column_name )
[ { AND | OR } UPDATE ( column_name ) ] ... ]
  statement-list
[ IF UPDATE ( column_name )
[ { AND | OR} UPDATE ( column_name ) ] ... ]
  statement-list




=====
--                             ICQ Web-based!!
----------------------------------------------
Sandrigo Lezcano Jara           ICQ: 143590717
Asuncion, Paraguay           http://go.icq.com

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com