From a9236028554ca0e11797c887373c1a34800a4fa6 Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Wed, 6 Jul 2005 19:02:54 +0000
Subject: Add pg_column_size() to return storage size of a column, including
 possible compression.

Mark Kirkwood
---
 doc/src/sgml/func.sgml | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index d837219421e..4ff434aca87 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -1,5 +1,5 @@
 <!--
-$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.262 2005/06/29 01:52:56 momjian Exp $
+$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.263 2005/07/06 19:02:52 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -2186,6 +2186,14 @@ PostgreSQL documentation
        <entry><literal>5</literal></entry>
       </row>
 
+      <row>
+       <entry><literal><function>pg_column_size</function>(<parameter>string</parameter>)</literal></entry>
+       <entry><type>integer</type></entry>
+       <entry>Number of bytes required to store the value, which might be compressed</entry>
+       <entry><literal>pg_column_size('jo\\000se'::bytea)</literal></entry>
+       <entry><literal>5</literal></entry>
+      </row>
+
       <row>
        <entry><literal><function>position</function>(<parameter>substring</parameter> in <parameter>string</parameter>)</literal></entry>
        <entry><type>integer</type></entry>
-- 
cgit v1.2.3