Thanks, Merlin! The "restack" function solves the problem! :)
> what are you trying to do w/unfold function exactly?
The recursive query I mentioned was to produce from the argument
array[array[1,2,3],array[4,5,6],array[7,8,9],array[10,11]] the result
array[1,2,3,4,5,6,7,8,9,10,11].
The behavio
On Thu, Apr 29, 2010 at 8:46 AM, Merlin Moncure wrote:
> On Wed, Apr 28, 2010 at 8:48 PM, Belka Lambda wrote:
>> Hi!
>>
>> I tried to write a recursive SELECT, that would do the concatination, but a
>> problem appeared:
>> can't make a {1,2,3} from {{1,2,3}}.
>> Here are some experiments:
>> ---
On Wed, Apr 28, 2010 at 8:48 PM, Belka Lambda wrote:
> Hi!
>
> I tried to write a recursive SELECT, that would do the concatination, but a
> problem appeared:
> can't make a {1,2,3} from {{1,2,3}}.
> Here are some experiments:
>
Hi!
I tried to write a recursive SELECT, that would do the concatination, but a
problem appeared:
can't make a {1,2,3} from {{1,2,3}}.
Here are some experiments:
---
postgres=# select array[array[1,2,3
