Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group