X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 4935431013F
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Jun 2003 20:49:06 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 22493-03
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu, 26 Jun 2003 17:48:55 -0300 (ADT)
Received: from rtp-core-1.cisco.com (rtp-core-1.cisco.com [64.102.124.12])
	by svr1.postgresql.org (Postfix) with ESMTP id 8534231015B
	for <pgsql-interfaces@postgresql.org>;
	Thu, 26 Jun 2003 17:48:55 -0300 (ADT)
Received: from unity.cisco.com (evvbu-exchange-100tx.cisco.com
 [64.101.140.74])
	by rtp-core-1.cisco.com (8.12.9/8.12.6) with SMTP id h5QKmrai026060
	for <pgsql-interfaces@postgresql.org>;
	Thu, 26 Jun 2003 16:48:54 -0400 (EDT)
Subject: Dissecting Tuples in C
From: Clay Luther <claycle@cisco.com>
To: pgsql-interfaces@postgresql.org
Content-Type: multipart/alternative; boundary="=-/cW1EbiYicK/Vd3n2tA0"
Organization: Cisco System, Inc.
Message-Id: <1056660353.22881.28.camel@gkar>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) 
Date: 26 Jun 2003 15:45:53 -0500
X-Archive-Number: 200306/83
X-Sequence-Number: 4294

--=-/cW1EbiYicK/Vd3n2tA0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

I am trying to get up to speed writing C triggers and I have a question
about the relation between HeapTuples and other tuple-related types,
like TupleTableSlots, and the routines and macros used to manipulate
them. I am reading and re-reading the online docs, but still have some
broad questions.

For example, suppose I just wanted a trigger to iterate through the
HeapTuple pointed at by the tirgger data tg_trigtuple, printing out the
column names, types, and values (lets say, only ints and strings for
simplicity). How would I do this?

A pointer to a good document would be just as good as a detailed answer.

Thanks!

-- 
Clay
claycle@cisco.com

--=-/cW1EbiYicK/Vd3n2tA0
Content-Type: text/html; charset=utf-8

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/1.1.8">
</HEAD>
<BODY>
I am trying to get up to speed writing C triggers and I have a question about the relation between HeapTuples and other tuple-related types, like TupleTableSlots, and the routines and macros used to manipulate them. I am reading and re-reading the online docs, but still have some broad questions.<BR>
<BR>
For example, suppose I just wanted a trigger to iterate through the HeapTuple pointed at by the tirgger data tg_trigtuple, printing out the column names, types, and values (lets say, only ints and strings for simplicity). How would I do this?<BR>
<BR>
A pointer to a good document would be just as good as a detailed answer.<BR>
<BR>
Thanks!<BR>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<PRE>-- 
Clay
claycle@cisco.com</PRE>
</TD>
</TR>
</TABLE>

</BODY>
</HTML>

--=-/cW1EbiYicK/Vd3n2tA0--