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
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
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
---(end of
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 two
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 SetCursor()
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) select
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 or
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
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
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
finished).
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
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
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 stored
Christian Rank wrote:
[EMAIL PROTECTED]:/home/postgres/pgsql/src/interfaces/ecpg$ ./a
[21964]: ECPGdebug: set to 1
[21964]: ECPGconnect: opening database mm on DEFAULT port DEFAULT
[21964]: ECPGexecute line 16: QUERY: select n from ton connection mm
[21964]: ECPGexecute line 16:
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 =
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
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
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
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 this
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 where
20 matches
Mail list logo
