Function to split pg_trigger.tgargs

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: Function to split pg_trigger.tgargs
Date: 2002-02-18 05:35:14
Message-ID: GNELIHDDFBOCMGBFGEFOEEGOCBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nicolas Bazin 2002-02-18 05:50:28 REf. cross-platform packaging in native format.
Previous Message Christopher Kings-Lynne 2002-02-18 04:08:28 Re: Patch to ALTER TABLE docs for 7.2.1

Browse pgsql-sql by date

  From Date Subject
Next Message D'laila Pereira 2002-02-18 07:51:32 all tables in a DB\?
Previous Message Bruce Momjian 2002-02-17 02:49:13 Re: create index on function - why?