pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>
To: pgsql-performance@postgresql.org
To: pgsql-novice@postgresql.org
Subject: Accessing insert values in triggers
Date: Wed, 02 Feb 2005 18:02:28 +0800
Message-ID: <4200A534.3030405@mimos.my> (raw)

Hi,

I am trying to build a function that would extend the trigger in general 
tid bits that would only track count changes for table rows.

The one i am trying to build would check which column and value should 
be tracked.

e.g. below would be the tracker.

CREATE TABLE "public"."aaaa" (
  "tables" TEXT,
  "columns" TEXT[],
  "values" TEXT[],
  "counts" BIGINT
) WITH OIDS;

The column array is the column name and the values array would be the 
values matching the columns array defined.

if columns has {group,item} then values has {1,'basket'} so if the data 
inserted matches the values defined, it will be tracked.

When new data is inserted, we have to use new.xxxx to access the data.  
Is there another way to access the data that would be more generic
like value[1] and so on?  This way, the tracker is independant of any 
tables.  i believe tg_argv is only for data being updated.

I'm have not done any functions in C, but for those who has, it is more 
possible to do it in C?  If those who has used it say i can access the 
data easier
in C, then i'll have to read up and learn it.

I was looking through the examples in the doc on creating triggers in 
C.  I believe the data i'm looking for is in tg_trigtuple but i am not 
sure how it is supposed to be accessed.  Anyone knows of any links i can 
refer to or anyones has simple codes showing how to access the data?

Thanks for any info.

Hasnul









view thread (2+ messages)  latest in thread

Message-ID: <4200A534.3030405@mimos.my>
Permalink:  ../4200A534.3030405@mimos.my/
Also on:    postgresql.org/message-id/4200A534.3030405@mimos.my

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: hasnulfadhly.h@mimos.my, pgsql-novice@postgresql.org
  Subject: Re: Accessing insert values in triggers
  In-Reply-To: <4200A534.3030405@mimos.my>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox