[HACKERS] Support for negative index values in array fetching

2011-01-02 Thread Valtonen, Hannu
Hi, I ran into the problem of getting the last n elements out of an array and while some workarounds do exist: (http://stackoverflow.com/questions/2949881/getting-the-last-element-of-a-postgres-array-declaratively) I was still annoyed that I couldn't just ask for the last n values in an array

[HACKERS] plpythonu DO support (inline call handler)

2009-11-17 Thread Valtonen, Hannu
Hi, The attached patch adds support for DO clause in plpythonu. It was heavily inspired by the plperl and plpgsql inline handler code. I couldn't figure out how to get added files to show in git diff so the two files that this patch adds: expected/plpython_do.out and

[HACKERS] Patch to add support for text/int arrays for plpythonu

2009-04-26 Thread Valtonen, Hannu
Hi, Attached is a small patch for adding support for INT[] and TEXT[] to plpythonu. There are also some small tests for this copypasted to the end of the mail. I'd like to get this into CVS but as it's probably a bit late for 8.4 I wouldn't mind it going into the first commitfest for 8.5.

Re: [HACKERS] Patch to add support for text/int arrays for plpythonu

2009-04-26 Thread Valtonen, Hannu
On 4/26/09 6:23 PM, Tom Lane wrote: Why in the world would you confine the feature to just two data types? This seems like a fundamentally incorrect approach. The reason why I wrote it that way is because that's the way plpythonu's conversion to python and back is set up. Without my