Added to TODO:
* Add array_accum() and array_to_set() functions for arrays
http://archives.postgresql.org/pgsql-hackers/2007-08/msg00464.php
---
Merlin Moncure wrote:
> On 8/14/07, Bruce Momjian <[EMAIL PROTECTED]> wrot
This has been saved for the 8.4 release:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold
---
Pavel Stehule wrote:
> 2007/8/15, Merlin Moncure <[EMAIL PROTECTED]>:
> > On 8/14/07, Bruce Momjian <[EMAIL PROTECTED
2007/8/15, Decibel! <[EMAIL PROTECTED]>:
> On Wed, Aug 15, 2007 at 06:47:05AM +0200, Pavel Stehule wrote:
> > 2007/8/14, Decibel! <[EMAIL PROTECTED]>:
> > > On Tue, Aug 14, 2007 at 05:38:33PM +0200, Pavel Stehule wrote:
> > > > 2007/8/14, Bruce Momjian <[EMAIL PROTECTED]>:
> > > > >
> > > > > TODO
On Wed, Aug 15, 2007 at 06:47:05AM +0200, Pavel Stehule wrote:
> 2007/8/14, Decibel! <[EMAIL PROTECTED]>:
> > On Tue, Aug 14, 2007 at 05:38:33PM +0200, Pavel Stehule wrote:
> > > 2007/8/14, Bruce Momjian <[EMAIL PROTECTED]>:
> > > >
> > > > TODO item?
> > > >
> > > > + If your life is a hard driv
2007/8/15, Merlin Moncure <[EMAIL PROTECTED]>:
> On 8/14/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> >
> > TODO item?
>
> I would say yes...array_accum is virtually an essential function when
> working with arrays and the suggested array_to_set (and it's built in
> cousin, _pg_expand_array) real
2007/8/14, Decibel! <[EMAIL PROTECTED]>:
> On Tue, Aug 14, 2007 at 05:38:33PM +0200, Pavel Stehule wrote:
> > 2007/8/14, Bruce Momjian <[EMAIL PROTECTED]>:
> > >
> > > TODO item?
> > >
> > > + If your life is a hard drive, Christ can be your backup. +
> > >
> > > ---(end o
On Tue, Aug 14, 2007 at 04:08:27PM -0500, Decibel! wrote:
> On Tue, Aug 14, 2007 at 05:38:33PM +0200, Pavel Stehule wrote:
> > 2007/8/14, Bruce Momjian <[EMAIL PROTECTED]>:
> > >
> > > TODO item?
> > >
> > > + If your life is a hard drive, Christ can be your backup. +
> > >
> > >
On 8/14/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> TODO item?
I would say yes...array_accum is virtually an essential function when
working with arrays and the suggested array_to_set (and it's built in
cousin, _pg_expand_array) really should not be built around
generate_series when a C funct
On Tue, Aug 14, 2007 at 05:38:33PM +0200, Pavel Stehule wrote:
> 2007/8/14, Bruce Momjian <[EMAIL PROTECTED]>:
> >
> > TODO item?
> >
> > + If your life is a hard drive, Christ can be your backup. +
> >
> > ---(end of broadcast)---
> > TIP 6: explai
Bruce Momjian wrote:
TODO item?
Probably. See SQL2003 UNNEST:
::=
UNNEST
[ WITH ORDINALITY ]
::=
|
Joe
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
2007/8/14, Bruce Momjian <[EMAIL PROTECTED]>:
>
> 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.
TODO item?
---
Michael Glaesemann wrote:
-- Start of PGP signed section.
>
> On Aug 8, 2007, at 12:18 , Decibel! wrote:
>
> > On Wed, Aug 08, 2007 at 12:03:34PM -0500, Michael Glaesemann wrote:
> >> Personally, I think exp
On Aug 8, 2007, at 12:18 , Decibel! wrote:
On Wed, Aug 08, 2007 at 12:03:34PM -0500, Michael Glaesemann wrote:
Personally, I think expandarray is more appropriate and its
functionality probably more generally useful, as it identifies the
array indices as well. Note you can also rename the colu
On Wed, Aug 08, 2007 at 12:03:34PM -0500, Michael Glaesemann wrote:
> Personally, I think expandarray is more appropriate and its
> functionality probably more generally useful, as it identifies the
> array indices as well. Note you can also rename the columns.
Sure. My point is that we should
On Aug 8, 2007, at 11:41 , Decibel! wrote:
On Tue, Aug 07, 2007 at 10:18:32PM -0700, Jeremy Drake wrote:
select * from information_schema._pg_expandarray(ARRAY['foo',
'bar', 'baz']);
x | n
-+---
foo | 1
bar | 2
baz | 3
(3 rows)
Not exactly well documented or well known, but it w
On Tue, Aug 07, 2007 at 10:18:32PM -0700, Jeremy Drake wrote:
> On Tue, 7 Aug 2007, Decibel! wrote:
>
> > ISTM that having a built-in array_to_set function would be awfully
> > useful... Is the aggregate method below an acceptable way to do it?
>
> Umm, the array_to_set function is not an aggrega
On Tue, 7 Aug 2007, Decibel! wrote:
> ISTM that having a built-in array_to_set function would be awfully
> useful... Is the aggregate method below an acceptable way to do it?
Umm, the array_to_set function is not an aggregate. Personally, when I
need this functionality, I use this function conve
ISTM that having a built-in array_to_set function would be awfully
useful... Is the aggregate method below an acceptable way to do it?
- Forwarded message from Merlin Moncure <[EMAIL PROTECTED]> -
On 8/3/07, Guy Fraser <[EMAIL PROTECTED]> wrote:
> On Wed, 2007-08-01 at 07:14 +0530, Merlin
18 matches
Mail list logo