David Garamond <[EMAIL PROTECTED]> writes:
> Greg Stark wrote:
> >>Actually, each record will be incremented probably only thousands of times a
> >>day. But there are many banners. Each record has a (bannerid, campaignid,
> >>websiteid, date, countrycode) "dimensions" and (impression, click) "meas
Robert,
I am currently evaluating PolyServe Matrix Server which is a clustering
solution including a clustered file system (mounted read-write
everywhere).
Anything special anyone wants to know? I'm using PostgreSQL 7.4.2 in
a Linux cluster.
Greg
Robert Treat wrote:
On Thu, 2004-05-20 at 14:30, Kr
Matthias Nagl <[EMAIL PROTECTED]> writes:
> For a table like this I am looking for a query that returns a result that
> looks this way:
>
> name
> -
> abc, def, ghi
You need something like this:
create function concat_agg_accum(varchar, varchar) returns varchar
as 'select
Matthias Nagl <[EMAIL PROTECTED]> writes:
> Let's say I've got a table in the following form:
> SELECT * FROM test;
> id | name
> ---
> 1 | abc
> 2 | def
> 3 | ghi
> For a table like this I am looking for a query that returns a result that
> looks this way:
> name
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
> I would like to combine the contents of several rows of a subquery. After
> several hours of search in the documentation and the internet I didn'T find
> a solution and hope anyone can help. My problem:
You have to create your own aggreate.
You
Matthias Nagl wrote:
Hello List!
I would like to combine the contents of several rows of a subquery. After
several hours of search in the documentation and the internet I didn'T find a
solution and hope anyone can help. My problem:
Let's say I've got a table in the following form:
SELECT * FROM
Hello List!
I would like to combine the contents of several rows of a subquery. After
several hours of search in the documentation and the internet I didn'T find a
solution and hope anyone can help. My problem:
Let's say I've got a table in the following form:
SELECT * FROM test;
id | name
Hello all,
I've discovered that in 7.4.2 PL/pgSQL, the FOUND variable is not at all
affected by use of the EXECUTE command, even if the statement you pass
to EXECUTE would set FOUND to true when run directly. The documentation
doesn't really point this out, and in my opinion, it's an unintuitiv
