diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-07-06 19:02:54 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-07-06 19:02:54 +0000 |
| commit | a9236028554ca0e11797c887373c1a34800a4fa6 (patch) | |
| tree | 58e500e5de9b36e88dbab01d73d208e20b30161e /doc/src | |
| parent | b9cb1326481302719ad8bdad6b6247bca42a629b (diff) | |
| download | postgresql-a9236028554ca0e11797c887373c1a34800a4fa6.tar.gz postgresql-a9236028554ca0e11797c887373c1a34800a4fa6.zip | |
Add pg_column_size() to return storage size of a column, including
possible compression.
Mark Kirkwood
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 10 |
1 files changed, 9 insertions, 1 deletions
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 --> @@ -2187,6 +2187,14 @@ PostgreSQL documentation </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> <entry>Location of specified substring</entry> |