Commit444c5bf

committed

SQL function bit_length

1 parent8a987af commit444c5bfCopy full SHA for 444c5bf

File tree

+18

-2

lines changed

+18

-2

lines changed

Lines changed: 9 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.58 2001/05/12 22:51:34 petere Exp $ -->`
	`1`	`+<!-- $Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.59 2001/05/24 09:29:29 petere Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="functions">`
`4`	`4`	`<title>Functions and Operators</title>`
`@@ -775,6 +775,14 @@`
`775`	`775`	`<entry>PostgreSQL</entry>`
`776`	`776`	`</row>`
`777`	`777`
	`778`	`+ <row>`
	`779`	`+ <entry>bit_length(<parameter>string</parameter>)</entry>`
	`780`	`+ <entry><type>integer</type></entry>`
	`781`	`+ <entry>number of bits in string</entry>`
	`782`	`+ <entry>bit_length('jose')</entry>`
	`783`	`+ <entry>32</entry>`
	`784`	`+ </row>`
	`785`	`+`
`778`	`786`	`<row>`
`779`	`787`	`<entry>char_length(<parameter>string</parameter>) or character_length(<parameter>string</parameter>)</entry>`
`780`	`788`	`<entry><type>integer</type></entry>`

Lines changed: 9 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`* Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group`
`8`	`8`	`* Portions Copyright (c) 1994, Regents of the University of California`
`9`	`9`	`*`
`10`		`- * $Id: pg_proc.h,v 1.187 2001/05/22 16:37:16 petere Exp $`
	`10`	`+ * $Id: pg_proc.h,v 1.188 2001/05/24 09:29:29 petere Exp $`
`11`	`11`	`*`
`12`	`12`	`* NOTES`
`13`	`13`	`* The script catalog/genbki.sh reads this file and generates .bki`
`@@ -2464,6 +2464,14 @@ DESCR("(internal)");`
`2464`	`2464`	`DATA(insertOID=1799 (oidoutPGUID12fttt1f23"0"10000100oidout- ));`
`2465`	`2465`	`DESCR("(internal)");`
`2466`	`2466`
	`2467`	`+`
	`2468`	`+DATA(insertOID=1810 (bit_lengthPGUID14fttt1f23"17"10000100"select octet_length($1) * 8"- ));`
	`2469`	`+DESCR("length in bits");`
	`2470`	`+DATA(insertOID=1811 (bit_lengthPGUID14fttt1f23"25"10000100"select octet_length($1) * 8"- ));`
	`2471`	`+DESCR("length in bits");`
	`2472`	`+DATA(insertOID=1812 (bit_lengthPGUID14fttt1f23"1560"10000100"select length($1)"- ));`
	`2473`	`+DESCR("length in bits");`
	`2474`	`+`
`2467`	`2475`	`/* Selectivity estimators for LIKE and related operators */`
`2468`	`2476`	`DATA(insertOID=1814 (iclikeselPGUID12ftft4f701"0 26 0 23"10000100iclikesel- ));`
`2469`	`2477`	`DESCR("restriction selectivity of ILIKE");`

Comments

(0)