diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-07-11 22:14:03 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-07-11 22:14:03 +0000 |
| commit | 7771436e184e1057efbe4c402c912dd1d7f773fe (patch) | |
| tree | 6916e4b376c72586acea3765096ba9b12cde9609 /doc/src | |
| parent | 4051bce27dea570b452e7181591319be45d9c917 (diff) | |
| download | postgresql-7771436e184e1057efbe4c402c912dd1d7f773fe.tar.gz postgresql-7771436e184e1057efbe4c402c912dd1d7f773fe.zip | |
> > Put encode() into base system. Used part of Alex' patch
> > for docs, hope he does not mind ;)
Marko Kreen
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 30 |
1 files changed, 29 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index c9205485f22..d4dda3c412a 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.63 2001/07/03 02:42:18 momjian Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.64 2001/07/11 22:14:01 momjian Exp $ --> <chapter id="functions"> <title>Functions and Operators</title> @@ -1051,6 +1051,34 @@ <entry>translate('12345', '14', 'ax')</entry> <entry>a23x5</entry> </row> + + <row> + <entry> + encode(<parameter>data</parameter> <type>bytea</type>, + <parameter>type</parameter> <type>text</type>) + </entry> + <entry><type>text</type></entry> + <entry> + Encodes binary data to ascii-only representation. Supported + types are: 'base64', 'hex'. + </entry> + <entry>encode('123\\000\\001', 'base64')</entry> + <entry>MTIzAAE=</entry> + </row> + + <row> + <entry> + decode(<parameter>string</parameter> <type>text</type>, + <parameter>type</parameter> <type>text</type>) + </entry> + <entry><type>bytea</type></entry> + <entry> + Decodes binary data from <parameter>string</parameter> previously + encoded with encode(). Parameter type is same as in encode(). + </entry> + <entry>decode('MTIzAAE=', 'base64')</entry> + <entry>123\000\001</entry> + </row> </tbody> </tgroup> |