View Revisions: Issue #815

Summary 0000815: decode() function needs qualified in most recent version of Greenplum
Revision 2012-09-12 01:11 by chenson
Description Symptoms:

ERROR: syntax error at or near ")"
LINE 1: SELECT encode(decode( $1 , 'escape'), 'base64')
                                           ^
QUERY: SELECT encode(decode( $1 , 'escape'), 'base64')
CONTEXT: SQL statement in PL/PgSQL function "sym_largeobject" near line 12

Discussion:
http://www.greenplum.com/community/forums/archive/index.php/t-715.html
Revision 2012-09-12 01:11 by chenson
Description
Symptoms:

ERROR: syntax error at or near ")"
LINE 1: SELECT encode(decode( $1 , 'escape'), 'base64')
                                           ^
QUERY: SELECT encode(decode( $1 , 'escape'), 'base64')
CONTEXT: SQL statement in PL/PgSQL function "sym_largeobject" near line 12

Discussion:
http://www.greenplum.com/community/forums/archive/index.php/t-715.html