# HG changeset patch # User Adrien Di Mascio # Date 1268917613 -3600 # Node ID ec27aea9632b1881e9c757f53170767c373f4582 # Parent 4e08eba12851eece1413d9010c980a256164b94a [sql] fix FSPATH implementation plpy.execute() returns a list of dictionaries with column names as keys and corresponding values as values. diff -r 4e08eba12851 -r ec27aea9632b schemas/_regproc_bss.postgres.sql --- a/schemas/_regproc_bss.postgres.sql Thu Mar 18 09:12:54 2010 +0100 +++ b/schemas/_regproc_bss.postgres.sql Thu Mar 18 14:06:53 2010 +0100 @@ -32,7 +32,7 @@ 'SELECT X.cw_%s FROM cw_%s as X WHERE X.cw_eid=$1' % (args[2], args[1]), ['bigint']) SD[pkey] = plan - return plpy.execute(plan, [args[0]])[0] + return plpy.execute(plan, [args[0]])[0]['cw_' + args[2]] $$ LANGUAGE plpythonu /* WITH(ISCACHABLE) XXX does postgres handle caching of large data nicely */ ;;