=?UTF-8?Q?Viktor_Bojovi=C4=87?= writes:
> I tried to write this part below, but something is wrong (ERROR: function
> grafika.pov_sphere(character varying, numeric, numeric, numeric, numeric,
> character varying) does not exist) so I wanted to ask if someone knows how
> to solve this problem.
Wel
Hi Steven,
I believe I saw something about a fix to array_append in the release notes
for V8.2. Not sure if this helps.
Steven Murdoch-2 wrote:
>
> I would like to aggregate several rows of a query, maintaining the
> relative order. Is there an other way to achive the same result? I
> have a
Mark,
Works beautifully. Thanks for the clear explanation and code!
-David
On Tue, 19 Oct 2004, Mark Gibson wrote:
> David Siegal wrote:
> > I would like to create an aggregate function that returns a concatenation
> > of grouped values. It would be particularly useful if I could pass an
> > op
David Siegal wrote:
I would like to create an aggregate function that returns a concatenation
of grouped values. It would be particularly useful if I could pass an
optional delimiter into the aggregate function.
I've managed to do this in two stages:
1. Collect the set of values into an array.
T
On Mon, Oct 18, 2004 at 11:24:33 -0400,
David Siegal <[EMAIL PROTECTED]> wrote:
>
> My problem is I don't see how to make aggregated_concat accept an
> optional delimiter argument.
> Maybe it's not possible?
>
> Any ideas?
> Is there some completely different approach I should consider for
> co
Is this a TODO?
---
Josh Berkus wrote:
> Kemin,
>
> > Just noticed that the postgres stddev is the stddev_sample formula.
> > There are two different ways to calculate this value.
> > Their difference is very small with lar
Kemin,
> Just noticed that the postgres stddev is the stddev_sample formula.
> There are two different ways to calculate this value.
> Their difference is very small with large samle size. It would be nice
> to distinguish the two different versions.
Note sent to PGSQL-DOCS.
> I also noticed th
Tom Lane wrote:
j knight <[EMAIL PROTECTED]> writes:
[ query with GROUP BY on a FULL JOIN USING column ]
psql:pgsql.dump:301: ERROR: column "r.day" must appear in the GROUP BY
clause or be used in an aggregate function
Argh. This is the result of a thinko in an optimization added in 7.4.
The
j knight <[EMAIL PROTECTED]> writes:
> [ query with GROUP BY on a FULL JOIN USING column ]
> psql:pgsql.dump:301: ERROR: column "r.day" must appear in the GROUP BY
> clause or be used in an aggregate function
Argh. This is the result of a thinko in an optimization added in 7.4.
The patch is att
