diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2001-05-24 09:29:29 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2001-05-24 09:29:29 +0000 |
| commit | 444c5bf1b29bbe7db107deddb80b7a70a990f32b (patch) | |
| tree | 2d17f24acc28c1b312b53ae0be1d1682cff3920c | |
| parent | 8a987af4a11a3fc3504bd35c06a106b12fd2a228 (diff) | |
| download | postgresql-444c5bf1b29bbe7db107deddb80b7a70a990f32b.tar.gz postgresql-444c5bf1b29bbe7db107deddb80b7a70a990f32b.zip | |
SQL function bit_length
| -rw-r--r-- | doc/src/sgml/func.sgml | 10 | ||||
| -rw-r--r-- | src/include/catalog/pg_proc.h | 10 |
2 files changed, 18 insertions, 2 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 4f1abbd89fa..c80ab6cf748 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.58 2001/05/12 22:51:34 petere Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.59 2001/05/24 09:29:29 petere Exp $ --> <chapter id="functions"> <title>Functions and Operators</title> @@ -776,6 +776,14 @@ </row> <row> + <entry>bit_length(<parameter>string</parameter>)</entry> + <entry><type>integer</type></entry> + <entry>number of bits in string</entry> + <entry>bit_length('jose')</entry> + <entry>32</entry> + </row> + + <row> <entry>char_length(<parameter>string</parameter>) or character_length(<parameter>string</parameter>)</entry> <entry><type>integer</type></entry> <entry> diff --git a/src/include/catalog/pg_proc.h b/src/include/catalog/pg_proc.h index 6b31f2a4b2b..83e1e504ccf 100644 --- a/src/include/catalog/pg_proc.h +++ b/src/include/catalog/pg_proc.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: pg_proc.h,v 1.187 2001/05/22 16:37:16 petere Exp $ + * $Id: pg_proc.h,v 1.188 2001/05/24 09:29:29 petere Exp $ * * NOTES * The script catalog/genbki.sh reads this file and generates .bki @@ -2464,6 +2464,14 @@ DESCR("(internal)"); DATA(insert OID = 1799 ( oidout PGUID 12 f t t t 1 f 23 "0" 100 0 0 100 oidout - )); DESCR("(internal)"); + +DATA(insert OID = 1810 ( bit_length PGUID 14 f t t t 1 f 23 "17" 100 0 0 100 "select octet_length($1) * 8" - )); +DESCR("length in bits"); +DATA(insert OID = 1811 ( bit_length PGUID 14 f t t t 1 f 23 "25" 100 0 0 100 "select octet_length($1) * 8" - )); +DESCR("length in bits"); +DATA(insert OID = 1812 ( bit_length PGUID 14 f t t t 1 f 23 "1560" 100 0 0 100 "select length($1)" - )); +DESCR("length in bits"); + /* Selectivity estimators for LIKE and related operators */ DATA(insert OID = 1814 ( iclikesel PGUID 12 f t f t 4 f 701 "0 26 0 23" 100 0 0 100 iclikesel - )); DESCR("restriction selectivity of ILIKE"); |