Hi postgres fans,
i'm already using the crosstab function but it shows up an issue with multiple
results in the same category. example table:
row_namecatvalue
--+---+---
row1 cat1val1
row1 cat1val2
row1 cat3val3
row1 cat4val4
Original-Nachricht
> Datum: Sun, 03 Apr 2011 16:25:35 +0200
> Von: Thomas Kellerer
> An: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] Table lock while adding a column and clients are
> logged in
> Sven Haag wrote on 03.04.2011 16:13:
> &g
Original-Nachricht
> Datum: Sun, 03 Apr 2011 15:37:17 +0200
> Von: Thomas Kellerer
> An: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] Table lock while adding a column and clients are
> logged in
> Alban Hertroys wrote on 03.04.2011 11:17:
> > On 2 Apr 2011, at 12:44,
Original-Nachricht
> Datum: Sat, 2 Apr 2011 14:17:37 +0200
> Von: Jens Wilke
> An: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] Autovacuum firing up during my manual vacuum on same
> table
> On Samstag, 2. April 2011, Henry C. wrote:
>
> > I just noticed something od
: Guillaume Lelarge
> An: Sven Haag
> CC: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] Table lock while adding a column and clients are
> logged in
> Le 02/04/2011 11:09, Sven Haag a écrit :
> > hello pg fans,
> >
> > we have an application that comm
hello pg fans,
we have an application that communicates via ODBC directly to the postgres
database.
if i'm trying to add an additional column to a table in pgadmin while clients
are logged in, pgadmin hangs. only if all cients are logged out it returns to
the normal state. according to our con
thanks a lot!
that function does it exactly as wished ;)!
Am 23.03.2011 22:46, schrieb Merlin Moncure:
On Wed, Mar 23, 2011 at 10:29 AM, Sven Haag wrote:
hello pgsql fans out there,
i've already created a function that returns a list of IDs of all sub-samples
based on a given samp
i guess an array is also ok. must been something like:
fn_get_subsamples(IN sample_numbers[] integer) ??
how would a query then look like?
SELECT * FROM sample WHERE sample_number IN ( fn_get_subsamples(1,2,3,4)
) ??
cheers sven
Am 23.03.2011 17:42, schrieb Tom Lane:
"Sven
hello pgsql fans out there,
i've already created a function that returns a list of IDs of all sub-samples
based on a given sample ID. this works fine. now i like to extend this function
so that it can receive a list of sample IDs. e.g.:
fn_get_subsamples(IN sample_numbers SETOF integer)
here
