[GENERAL] SPI_ERROR_UNCONNECTED in python callback function

I am using PL/Python to make queries via SPI. This seems to work when the query is made directly, but when I pass a function as a callback to an external module (in this case, python's cheetah templating engine), the function fails thusly: =# select common.template(8963,1); ERROR: plpython: fu

Re: [GENERAL] Replace null values

On Tue, Mar 23, 2010 at 5:33 PM, Nilesh Govindarajan wrote: > On 03/23/2010 11:47 AM, John R Pierce wrote: >> >>> How to convert zero length string to null ? >> >> >> >> UPDATE yourtable SET name=NULL WHERE name=''; >> >> > > No I don't want to replace it in the table. Just in the query result. us