<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML ><HEAD ><TITLE >SPI_freetuptable</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 7.4.1 Documentation" HREF="index.html"><LINK REL="UP" TITLE="Memory Management" HREF="spi-memory.html"><LINK REL="PREVIOUS" TITLE="SPI_freetuple" HREF="spi-spi-freetuple.html"><LINK REL="NEXT" TITLE="SPI_freeplan" HREF="spi-spi-freeplan.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="stylesheet.css"><META NAME="creation" CONTENT="2003-12-22T03:48:47"></HEAD ><BODY CLASS="REFENTRY" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="5" ALIGN="center" VALIGN="bottom" >PostgreSQL 7.4.1 Documentation</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="spi-spi-freetuple.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="spi-spi-freetuple.html" >Fast Backward</A ></TD ><TD WIDTH="60%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="top" ><A HREF="spi-spi-freeplan.html" >Fast Forward</A ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="top" ><A HREF="spi-spi-freeplan.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="SPI-SPI-FREETUPLETABLE" ></A >SPI_freetuptable</H1 ><DIV CLASS="REFNAMEDIV" ><A NAME="AEN34446" ></A ><H2 >Name</H2 >SPI_freetuptable -- free a row set created by <CODE CLASS="FUNCTION" >SPI_exec</CODE > or a similar function</DIV ><A NAME="AEN34450" ></A ><DIV CLASS="REFSYNOPSISDIV" ><A NAME="AEN34452" ></A ><H2 >Synopsis</H2 ><PRE CLASS="SYNOPSIS" >void SPI_freetuptable(SPITupleTable * <VAR CLASS="PARAMETER" >tuptable</VAR >)</PRE ></DIV ><DIV CLASS="REFSECT1" ><A NAME="AEN34455" ></A ><H2 >Description</H2 ><P > <CODE CLASS="FUNCTION" >SPI_freetuptable</CODE > frees a row set created by a prior SPI command execution function, such as <CODE CLASS="FUNCTION" >SPI_exec</CODE >. Therefore, this function is usually called with the global variable <VAR CLASS="VARNAME" >SPI_tupletable</VAR > as argument. </P ><P > This function is useful if a SPI procedure needs to execute multiple commands and does not want to keep the results of earlier commands around until it ends. Note that any unfreed row sets will be freed anyway at <CODE CLASS="FUNCTION" >SPI_finish</CODE >. </P ></DIV ><DIV CLASS="REFSECT1" ><A NAME="AEN34463" ></A ><H2 >Arguments</H2 ><P ></P ><DIV CLASS="VARIABLELIST" ><DL ><DT ><TT CLASS="LITERAL" >SPITupleTable * <VAR CLASS="PARAMETER" >tuptable</VAR ></TT ></DT ><DD ><P > pointer to row set to free </P ></DD ></DL ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="spi-spi-freetuple.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="spi-spi-freeplan.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >SPI_freetuple</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="spi-memory.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >SPI_freeplan</TD ></TR ></TABLE ></DIV ></BODY ></HTML >