From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Decibel! <decibel(at)decibel(dot)org> |
Cc: | "Bruce Momjian" <bruce(at)momjian(dot)us>, "Michael Glaesemann" <grzm(at)seespotcode(dot)net>, "Jeremy Drake" <pgsql(at)jdrake(dot)com>, "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions] |
Date: | 2007-08-15 04:47:05 |
Message-ID: | 162867790708142147u3596fd5es802d1b32a9fb1a40@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
2007/8/14, Decibel! <decibel(at)decibel(dot)org>:
> On Tue, Aug 14, 2007 at 05:38:33PM +0200, Pavel Stehule wrote:
> > 2007/8/14, Bruce Momjian <bruce(at)momjian(dot)us>:
> > >
> > > TODO item?
> > >
> > > + If your life is a hard drive, Christ can be your backup. +
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 6: explain analyze is your friend
> >
> > I am against. It's too simple do it in SQL language.
>
> Why make everyone who works with arrays create a function just to do
> this? Something that's of use to common users should be included, simple
> or not.
> --
Unpacking array is more SQL construct for me, than SRF function. With
function you cannot conntrol behave of unpacking. With SQL construct I
can
SELECT DISTINCT a(i) FROM generate_series ... remove duplicities
SELECT a(i) FROM generate_series ORDER BY .. sorted output
etc
But I can
SELECT * FROM generate_series(ARRAY[1,3,4,5,7,10]);
else
FUNCTION generate_series(anyarray) returns setof any
Regards
Pavel Stehule
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2007-08-15 04:50:44 | Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions] |
Previous Message | Oleg Bartunov | 2007-08-15 04:33:16 | Re: default_text_search_config and expression indexes |