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

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

Responses

Browse pgsql-es-ayuda by date

  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)