<!--

$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.132 2002/11/23 04:04:43 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.133 2002/12/05 04:38:29 momjian Exp $

PostgreSQL documentation

-->

shown in <xref linkend="functions-math-bit-table">.

Bit string arguments to <literal>&</literal>, <literal>|</literal>,

and <literal>#</literal> must be of equal length. When bit

shifting, the original length of the string is preserved, as shown in the table.

shifting, the original length of the string is preserved, as shown

in the table.

</para>

<table id="functions-math-bit-table">

<entry><literal>trim('\\000'::bytea from '\\000Tom\\000'::bytea)</literal></entry>

<entry><literal>Tom</literal></entry>

</row>

<row>

<entry><function>get_byte</function>(<parameter>string</parameter>, <parameter>offset</parameter>)</entry>

<entry><type>integer</type></entry>

<entry>

Extract byte from string.

<indexterm>

<primary>get_byte</primary>

</indexterm>

</entry>

<entry><literal>get_byte('Th\\000omas'::bytea, 4)</literal></entry>

<entry><literal>109</literal></entry>

</row>

<row>

<entry><function>set_byte</function>(<parameter>string</parameter>, <parameter>offset</parameter>)</entry>

<entry><type>bytea</type></entry>

<entry>

Set byte in string.

<indexterm>

<primary>set_byte</primary>

</indexterm>

</entry>

<entry><literal>set_byte('Th\\000omas'::bytea, 4, 64)</literal></entry>

<entry><literal>Th\000o@as</literal></entry>

</row>

<row>

<entry><function>get_bit</function>(<parameter>string</parameter>, <parameter>offset</parameter>)</entry>

<entry><type>integer</type></entry>

<entry>

Extract bit from string.

<indexterm>

<primary>get_bit</primary>

</indexterm>

</entry>

<entry><literal>get_bit('Th\\000omas'::bytea, 45)</literal></entry>

<entry><literal>1</literal></entry>

</row>

<row>

<entry><function>set_bit</function>(<parameter>string</parameter>, <parameter>offset</parameter>)</entry>

<entry><type>bytea</type></entry>

<entry>

Set bit in string.

<indexterm>

<primary>set_bit</primary>

</indexterm>

</entry>

<entry><literal>set_bit('Th\\000omas'::bytea, 45, 0)</literal></entry>

<entry><literal>Th\000omAs</literal></entry>

</row>

</tbody>

</tgroup>

</table>

DATA(insertOID=720 (octet_lengthPGNSPPGUID12fftfi123"17"byteaoctetlen-_null_ ));

DESCR("octet length");

DATA(insertOID=721 (get_bytePGNSPPGUID12fftfi223"17 23"byteaGetByte-_null_ ));

DESCR("");

DESCR("get byte");

DATA(insertOID=722 (set_bytePGNSPPGUID12fftfi317"17 23 23"byteaSetByte-_null_ ));

DESCR("");

DESCR("set byte");

DATA(insertOID=723 (get_bitPGNSPPGUID12fftfi223"17 23"byteaGetBit-_null_ ));

DESCR("");

DESCR("get bit");

DATA(insertOID=724 (set_bitPGNSPPGUID12fftfi317"17 23 23"byteaSetBit-_null_ ));

DESCR("");

DESCR("set bit");

DATA(insertOID=725 (dist_plPGNSPPGUID12fftfi2701"600 628"dist_pl-_null_ ));

DESCR("distance between point and line");