Function to split pg_trigger.tgargs - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Function to split pg_trigger.tgargs
Date
Msg-id GNELIHDDFBOCMGBFGEFOEEGOCBAA.chriskl@familyhealth.com.au
Whole thread Raw
List pgsql-sql
Hi All,

Is there a function in the catalogs somewhere that will split this?:

australia=# select tgargs from pg_trigger where oid=3842228;                                            tgargs

----------------------------------------------------------------------------
------
--------------

<unnamed>\000users_mealplans_prefs\000medidiets_meals\000UNSPECIFIED\000meal
_id\0
00meal_id\000
(1 row)

I'm hoping to do the splitting within pl/pgsql even.  If there is no
function to break it up, can someone please suggest how I would code taking
this string and breaking it into components.

Chris



pgsql-sql by date:

Previous
From: Mark Nielsen
Date:
Subject: Re: Join Statements
Next
From: Luis Sousa
Date:
Subject: Sequence in the rules