trigger wont use internal function? 
Author Message
 trigger wont use internal function?

I am trying to use the following trigger:

CREATE TRIGGER formatname BEFORE update OR insert ON mytable FOR EACH row
EXECUTE PROCEDURE lower(name);

however, it gives me the message:

ERROR:  CreateTrigger: function lower() does not exist

obviously this does exist, since I can do inserts/updates/selects using
lower(). I have also tried creating my own version of a lower function but
it gives me the same message.

Am I missing something? This seems like it should be pretty straightforward.
tia,

robert

---------------------------(end of broadcast)---------------------------



Sat, 10 Jan 2004 00:53:59 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Creating SQL Server internal functions / functions

2. Using Functions in Triggers

3. Using triggers vs. Multiple Functions in Stored Proc

4. Triggers on append using aggregate functions in an update statement

5. using NEW in a trigger calling a function in plpgsq

6. triggers on views wont compile-invalid object??

7. trigger wont fire (Enterprise Server 11.0.3.3)

8. Trigger - wont allow me to insert

9. SQL7 db wont show columns when doing a query using enterprise manager

10. internal function

11. question re internal functions requiring initdb

12. Doc for Internal Functions of ESQL-C


 
Powered by phpBB® Forum Software