| From: | sandrigo lezcano <alkafes(at)yahoo(dot)com> | 
|---|---|
| To: | pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx | 
| Subject: | [Pgsql-ayuda] triggers...if UPDATE(nombre_campo) then.... | 
| Date: | 2003-08-19 15:29:13 | 
| Message-ID: | 20030819152913.19972.qmail@web20005.mail.yahoo.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-es-ayuda | 
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2003-08-19 18:09:52 | Re: [Pgsql-ayuda] triggers...if UPDATE(nombre_campo) then.... | 
| Previous Message | Marcelo Retamal Vallejos | 2003-08-19 14:28:11 | [Pgsql-ayuda] (no subject) |