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] wrote:
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]
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 drive, Christ can be your
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 item?
+ If
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
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.
Regards
Bruce Momjian wrote:
TODO item?
Probably. See SQL2003 UNNEST:
collection derived table ::=
UNNEST left paren collection value expression right paren
[ WITH ORDINALITY ]
collection value expression ::=
array value expression
| multiset value expression
Joe
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: explain analyze is
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 function
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. +
---(end of
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 of
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) really should
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 aggregate.
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
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 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
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
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
18 matches
Mail list logo