Re: function does not exist error...

Dan,

> The big picture of what I'm trying to do is that I have large flat
> file of records created with info about individual recordings
> (songs).  I want to split those out into appropriately referenced
> tables.
>
> I thought I could create a combination of rules and triggers to step
> through the table (or a text file exported from it) and send the data
> where it needs to go.  Part of the process would be to check for
> existing entries to prevent redundency. I also want be able to add
> entries to join tables on the fly.

Why do you want to use Triggers and Rules?   Do you need to import this data
from source daily?  Even so, batch processing will be faster than executing a
trigger for each row inserted.

--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology     josh@agliodbs.com
    and data management solutions     (415) 565-7293
   for law firms, small businesses      fax 621-2533
    and non-profit organizations.     San Francisco