Re: Splitting text column to multiple rows
От | Andrus |
---|---|
Тема | Re: Splitting text column to multiple rows |
Дата | |
Msg-id | C0A3EB70B9C347DF863C660F33ADE4E3@andrusnotebook обсуждение исходный текст |
Ответ на | Re: Splitting text column to multiple rows (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Splitting text column to multiple rows
|
Список | pgsql-general |
I changed unction name and tried: CREATE OR REPLACE FUNCTION unnest21(anyarray) RETURNS SETOF anyelement as $$ SELECT $1[i] FROM generate_series(1,4) g(i) $$ LANGUAGE sql; select unnest21(string_to_array('23,2,3,4,5',',')); In this case it returns only 4 rows. No idea what is happening. Andrus. ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Andrus" <kobruleht2@hot.ee> Cc: "Pavel Stehule" <pavel.stehule@gmail.com>; <pgsql-general@postgresql.org> Sent: Monday, March 29, 2010 6:00 PM Subject: Re: [GENERAL] Splitting text column to multiple rows > "Andrus" <kobruleht2@hot.ee> writes: >> Pavel, >>> pavel@postgres:5481=# select unnest(string_to_array('23,2,3,4,5',',')); >>> unnest >>> -------- >>> 23 >>> 2 >>> 3 >>> 4 >>> (4 rows) > >> Result is wrong: it must contain 5 rows. > > Surely that's a copy-and-paste mistake? I get 5 rows from this example. > > regards, tom lane
В списке pgsql-general по дате отправления: