[SQL] Re: [SQL] unnesting of array of different size explodes memory

2011-04-13 Thread Charlie
Another approach to consider is using strings. E.g. The function assembles the underlying query as a string and returns the results of executing the string. Passing the groups in a string may be straightforward in your application, or not. There was a thread in the novice forum last year

Re: [SQL] Why don't I get a LATIN1 encoding here with SET ENCODING?

2009-11-03 Thread Craig Ringer
n any of this so long as you're using a client encoding that preserves the lower 128 characters, ie basically anything except shift-jis. Now, if your 'object' is actually a string in a single known text encoding, not just a sequence of bytes, then another approach is possible. First,