Robert Fitzpatrick wrote: > How can I reference any NEW field in an insert/update trigger function? > When someone inserts or updates any field with a single asterisk (*), I > need it to become '%%%'. But if they use an asterisk in any combination > with other fields, then I want to TRANSLATE those asterisks to a single > '%'.
You can't do that with PL/pgSQL. You can with other languages like PL/Perl though (which has better tools for string treatment, so it is a good idea anyway). -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
