Hi all,
I have a table trans with the data
price | volume | date | time
---+++--
79.87 |500 | 2006-06-01 | 13:30:14.262
79.87 |900 | 2006-06-01 | 13:30:15.375
79.85 |200 | 2006-06-01 | 13:30:17.381
79.85 |500 | 2006-06-01 |
Hi!
Do something like this
http://fimi.cvs.sourceforge.net/fimi/database/defaults/indicators/myinttick2bar.sql?revision=1.3&view=markup
and replace the max / min calculation with a count calculation.
Cheers
Chris
On Wed, August 22, 2007 9:25 am, roopa perumalraja wrote:
> Hi all,
>
> I ha
Hi all!
I'm building a database creation script, and i want to modularize it.
Now, I'm trying something like:
/*
- Customer creation script
- Version : 1.0.0
*/
\set ON_ERROR_STOP 1
\set AUTOCOMMIT off
BEGIN;
\i languages_and_countries.sql
\i app_1.sql
\i app_2.sql
[...]
END;
What do you
Hi,
I'm not sure if you have access to a scripting language (like perl or
ruby) but my experience is that if you transform the source text file
into a secondary text file that postgres "copy" can read
natively/directly into the data formats you want, the copy command will
move everything into
Hi Christian,
Thanks for your reply. Is it possible to use sub query to do this without
using the IF ELSE LOOP?
Cheers
Roopa
Christian Kindler <[EMAIL PROTECTED]> wrote:
Hi!
Do something like this
http://fimi.cvs.sourceforge.net/fimi/database/defaults/indicators/myinttick2bar.
Hello all,
Imagine having this table:
create table user_history (
rec_id SERIAL not null,
date TIMESTAMPnot null,
action INT2 not null,
uid INT4 not null,
name C
Its really slow but what you can do is something like the following:
select count(a.*), b.* from foo.bar a,
(
select price from foo.bar order by time asc limit 1
union
select price from foo.bar order by time desc limit 1
) as b
group by b.price
... just do the "wheres" as you need ...
Chris
"Aleksandr Vinokurov" <[EMAIL PROTECTED]> writes:
> The question is why "explain analyze" shows a 'Filter: ("action" <> 0)' in
> plan:
Use a newer Postgres release (8.1 or later).
regards, tom lane
---(end of broadcast)---
Thank you Tom,
but does it means that this is only an explain's problem or the plan
is actually such a hard, and postmaster actually checks each record
found by the index with this "filter"?
I'm using 8.0.1 version, but upgrading can become a work with expense.
On 22/08/07, Tom Lane <[EMAIL PROT
On 8/22/07, Aleksandr Vinokurov <[EMAIL PROTECTED]> wrote:
>
> create table user_history (
>rec_id SERIAL not null,
>date TIMESTAMPnot null,
>action INT2 not null,
>uid INT4 not
Scott Marlowe wrote:
>
> I don't see the issue here. The index being used is the same partial
> index you created. Maybe it's just a question of semantics?
>
As I understand final filter is:
a) pointed at the index creation
b) is redundant as all the indexed records have action
before i start reinventing the wheel does anyone have handy a function (or
straight SQL) for calculating the centerpoint coordinates and the radius of the
minimum bounding circle (not the the circumcircle) of a triangle (coordinates
of 3 points given as inputs).
a bonus would be a generalizati
12 matches
Mail list logo
