Re: [ADMIN] returning results from plsql function to plpythonu function

2011-12-03 Thread c k
Lou Picciano > > -- > *From: *"c k" > *To: *"Lou Picciano" > *Cc: *"pgsql-admin" , > pgsql-gene...@postgresql.org > *Sent: *Saturday, December 3, 2011 1:01:39 PM > *Subject: *Re: [ADMIN] returning results from plsql

Re: [ADMIN] returning results from plsql function to plpythonu function

2011-12-03 Thread Lou Picciano
erations on something not yet quite a string! Pythons are dangerous. Be careful! Lou Picciano - Original Message - From: "c k" To: "Lou Picciano" Cc: "pgsql-admin" , pgsql-gene...@postgresql.org Sent: Saturday, December 3, 2011 1:01:39 PM Subject: Re: [AD

Re: [ADMIN] returning results from plsql function to plpythonu function

2011-12-03 Thread c k
when I modified the notice statement as plpy.notice('%s' %results[0]) it prints notice as NOTICE: {'func1': 'function return text'} I didn't understand why it is showing 'func1' in the results[0] ? C P Kulkarni On Sat, Dec 3, 2011 at 11:31 PM, c k wrote: > can you please give me the example

Re: [ADMIN] returning results from plsql function to plpythonu function

2011-12-03 Thread c k
can you please give me the example I am not a python programmer. C P Kulkarni On Sat, Dec 3, 2011 at 11:25 PM, Lou Picciano wrote: > CP - You're missing a line in the middle; one which will extract specific > content(s) from $results. > > Because, yes, without such a line, python will only retu

Re: [ADMIN] returning results from plsql function to plpythonu function

2011-12-03 Thread Lou Picciano
CP - You're missing a line in the middle; one which will extract specific content(s) from $results. Because, yes, without such a line, python will only return the object reference. Lou Picciano - Original Message - From: "c k" To: "pgsql-admin" , pgsql-gene...@postgresql.org Sent