[GENERAL] weird query runtime results...

hello pg'lers, we are facing a puzzle, and was wondering if you could advise? db has been just vacuumed: table as: CREATE TABLE bigdb.t_rrddata ( f_insrt_dt timestamptz, f_timestamp int4 NOT NULL, f_site_a text NOT NULL, f_site_b text NOT NULL, f_probe text NOT NULL, f_ipv varchar N

[GENERAL] user defined aggregate for percentile calculations

cant seem to find anything about this, would it possible at all to create a percentile-aggregate in pgres? any pointers? tia -k -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] user defined aggregate for percentile calculations

L] user defined aggregate for percentile calculations In response to Kashmir : > > cant seem to find anything about this, > would it possible at all to create a percentile-aggregate in pgres? > any pointers? > tia > -k I'm not sure if i understand your problem, but how ab

[GENERAL] some external sql not working in psql

i'm in need of some psql advise, believe its rather a trivial issue, but confusing for me... (and hope this is the correct list for this?) facing following issue: got 2 tables like: CREATE TABLE td_fetch_by_rrd_id ( f_rrd_id numeric NOT NULL, f_timestamp numeric NOT NULL, f_ds numeric, f_