Re: Splitting text column to multiple rows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Andrus <kobruleht2(at)hot(dot)ee>, pgsql-general(at)postgresql(dot)org
Subject: Re: Splitting text column to multiple rows
Date: 2010-03-29 15:29:20
Message-ID: 13857.1269876560@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
> 2010/3/29 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>> I think if it appeared to work before it was because the built-in
>> unnest() function was capturing the call.

> he uses 8.1. the bug is in "generate_series(1,>>>4<<<)"

If renaming the function makes it appear to work differently,
then there is another function of similar name in there somewhere.
I'm betting the server is not 8.1 after all.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Gage 2010-03-29 15:29:56 How long will the query take
Previous Message Pavel Stehule 2010-03-29 15:18:30 Re: Splitting text column to multiple rows