schemas/_regproc_bss.postgres.sql
changeset 4951 7dc54e12c606
parent 4941 ec27aea9632b
equal deleted inserted replaced
4945:356662a6f06c 4951:7dc54e12c606
    30         # version content eid */
    30         # version content eid */
    31         plan = plpy.prepare(
    31         plan = plpy.prepare(
    32             'SELECT X.cw_%s FROM cw_%s as X WHERE X.cw_eid=$1' % (args[2], args[1]),
    32             'SELECT X.cw_%s FROM cw_%s as X WHERE X.cw_eid=$1' % (args[2], args[1]),
    33             ['bigint'])
    33             ['bigint'])
    34         SD[pkey] = plan
    34         SD[pkey] = plan
    35     return plpy.execute(plan, [args[0]])[0]
    35     return plpy.execute(plan, [args[0]])[0]['cw_' + args[2]]
    36 $$ LANGUAGE plpythonu
    36 $$ LANGUAGE plpythonu
    37 /* WITH(ISCACHABLE) XXX does postgres handle caching of large data nicely */
    37 /* WITH(ISCACHABLE) XXX does postgres handle caching of large data nicely */
    38 ;;
    38 ;;