This page in other versions: 8.4 / 9.0 / 9.1 / 9.2 / 9.3  |  Development versions: devel  |  Unsupported versions: 7.4 / 8.0 / 8.1 / 8.2 / 8.3

39.3. Data Values in PL/Tcl

The argument values supplied to a PL/Tcl function's code are simply the input arguments converted to text form (just as if they had been displayed by a SELECT statement). Conversely, the return command will accept any string that is acceptable input format for the function's declared return type. So, within the PL/Tcl function, all values are just text strings.

Comments


March 25, 2010, 12:09 p.m.

bytea data needs to be translated to/from PostgreSQL bytea escaping. This can be done using code such as:

set binary_data [ string map { \\000 \000 \\\\ \\ } $1 ]

and

return [ string map { \000 \\000 \\ \\\\ } $binary_data ]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group