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

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.


---------------------------(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

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