Shelby Cain <[EMAIL PROTECTED]> writes:
> Consider the following queries:
> #1) explain analyze select txn_code, count(*) from
> inventory_txns where txn_date > '07-FEB-2004' and
> txn_date <= current_date group by txn_code;
> #2) explain analyze select txn_code, count(*) from
> inventory_txns wh
On Mon, 8 Mar 2004, javier garcia - CEBAS wrote:
> Hi;
> Is it possible to directly create postgres tables with a timestamp column
> with some specific interval and within a specific range.
> For example every 5 minutes and between the beginning of 1999 and the end of
> 2003?
>
> I just need th
javier garcia - CEBAS wrote:
Is it possible to directly create postgres tables with a timestamp column
with some specific interval and within a specific range.
For example every 5 minutes and between the beginning of 1999 and the end of
2003?
You could create a function to return that data, and f
Standard cygwin Postgresql 7.4.1 package on Windows
2000 box.
I have a relatively small table (about 1 million
records) that contains inventory transaction data with
an index on transaction date (date datatype). Since
the data was inserted chronologically, the transaction
date column is strongly
Hi;
Is it possible to directly create postgres tables with a timestamp column
with some specific interval and within a specific range.
For example every 5 minutes and between the beginning of 1999 and the end of
2003?
I just need this column.
Thanks for your help.
Best regards,
Javier
--
On Fri, 5 Mar 2004 [EMAIL PROTECTED] wrote:
>
> Hey all,
>
> I'm using PostgreSQL 7.3.4.
>
> I have a query that isn't using a particular index, and I'm wondering why.
>
> The query is:
> select i.ItemID, d.Extension from ITEM i, SHARING s, DOCUMENT d where
> i.ItemID = d.ItemID AND s.ItemID =
Christian Rank wrote:
> > [EMAIL PROTECTED]:/home/postgres/pgsql/src/interfaces/ecpg$ ./a
> > [21964]: ECPGdebug: set to 1
> > [21964]: ECPGconnect: opening database mm on port
> > [21964]: ECPGexecute line 16: QUERY: select n from ton connection mm
> > [21964]: ECPGexecute line 16: Correc
On Mon, 8 Mar 2004, Markus Wollny wrote:
> Hi!
>
> As ODBC seems to be blissfully unaware of any character encodings
> whatsoever, so were we - our databases are encoded in SQL_ASCII,
> although we have stored german special chars (ÄÖÜäöü and ß), and from
> what I have read so far, these are st
Hi!
We've been using PostgreSQL (currently 7.4) via ODBC with ColdFusion
until now and didn't experience any problems. But now we want to move
from ColdFusion 4.5 to ColdFusion MX, thus abandoning ODBC and migrating
to JDBC.
As ODBC seems to be blissfully unaware of any character encodings
whatso
Andrew Rawnsley <[EMAIL PROTECTED]> writes:
> It is a fairly well known optimization in Oracle (at least with the
> rule-based optimizer, and IIRC non-indexed clauses) to optimize the
> WHERE clause right to left.
That rule doesn't apply to Postgres, though.
If the optimizer does not have any r
Vladimir Drobny <[EMAIL PROTECTED]> writes:
> I have problem with my postgres server. I am running postgres
> 7.3.4 on RedHat9 (shrike) on dual processor machine.
> Sometimes (cca 3 times per day) postmaster service will freeze
> with 100% CPU load with SELECT statement (statement is never
> finish
On Mar 8, 2004, at 5:40 AM, Chris wrote:
in a 'SELECT', does postgres read the 'WHERE' condition from left to
right.
PostgreSQL (SQL in general?) does NOT define evaluation order (unlike
programming languages like C).
It is a fairly well known optimization in Oracle (at least with the
rule-base
Hello pgsql-general,
I have problem with my postgres server. I am running postgres
7.3.4 on RedHat9 (shrike) on dual processor machine.
Sometimes (cca 3 times per day) postmaster service will freeze
with 100% CPU load with SELECT statement (statement is never
finished). If I try the same action ag
> in a 'SELECT', does postgres read the 'WHERE' condition from left to right.
PostgreSQL (SQL in general?) does NOT define evaluation order (unlike
programming languages like C).
> for example
> 1) select ... where a and b;
> 2) select ... where b and a;
>
> 1 and 2 will use the same cpu time
Sorry for my last blank post, anyway, im not sure this helps but have
you tried using EXPLAIN?
Dexter Tad-y
On Mon, 2004-03-08 at 17:41, sferriol wrote:
> hello
> in a 'SELECT', does postgres read the 'WHERE' condition from left to right.
>
> for example
> 1) select ... where a and b;
> 2) sele
Ooooppss..
I am extremely sorry. I took up the wrong mailing
address from my address book. It should have been
posted to wxWindows mailing list.
Regards
Karam
--- Karam Chand <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I want to implement HAND_CURSOR for my app so I have
> ot ifdef SetCurso
On Monday 08 March 2004 09:41, sferriol wrote:
> hello
> in a 'SELECT', does postgres read the 'WHERE' condition from left to right.
>
> for example
> 1) select ... where a and b;
> 2) select ... where b and a;
>
> 1 and 2 will use the same cpu time or not ?
I really wouldn't worry about it, for t
On Mon, 2004-03-08 at 17:41, sferriol wrote:
> hello
> in a 'SELECT', does postgres read the 'WHERE' condition from left to right.
>
> for example
> 1) select ... where a and b;
> 2) select ... where b and a;
>
> 1 and 2 will use the same cpu time or not ?
>
> sylvain
-
hello
in a 'SELECT', does postgres read the 'WHERE' condition from left to right.
for example
1) select ... where a and b;
2) select ... where b and a;
1 and 2 will use the same cpu time or not ?
sylvain
smime.p7s
Description: S/MIME Cryptographic Signature
Hello,
I want to implement HAND_CURSOR for my app so I have
ot ifdef SetCursor() and load it accordingly in my
windows app.
Here is the code I am using:
#ifdef _WIN32
m_HandCursor= wxCursor ( wxCURSOR_HAND );
#else
m_HandCursor=
20 matches
Mail list logo