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: | Raw Message | Whole Thread | 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) |