?
Thanks,
jan.
-Original Message-
From: Jaime Casanova [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 20:22
To: jan aerts (RI)
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] combination of function to simple query
makes query slow
On 10/3/05, jan aerts (RI) [EMAIL PROTECTED] wrote
jan aerts (RI) [EMAIL PROTECTED] writes:
My Postgres version is 7.3.4 (on a central server, so I can't upgrade if
that would be one of the suggestions...)
7.3.4 has multiple known data-loss bugs and security issues. If you're
dealing with someone who won't upgrade it, find someone else to deal
aerts (RI)
Sent: 30 September 2005 17:02
To: pgsql-sql@postgresql.org
Subject: [SQL] combination of function to simple query makes
query slow
Hi,
I'm having some problems in combining a function within a
standard query.
I basically have two tables (see between hashes below
On 10/3/05, jan aerts (RI) [EMAIL PROTECTED] wrote:
Some more information:
An EXPLAIN of the following query
my_db= explain select m1.object1_id, m1.object2_id, m2.object1_id,
m2.object2_id
my_db- from c_mappings m1, c_mappings m2
my_db- where m1.object1_id = 16575564
my_db- and
Hi,
I'm having some problems in combining a function within a standard
query.
I basically have two tables (see between hashes below):
* alias_table: objects can have different names (e.g. name1 is an alias
of name2, and name3 is an alias of name4)
* mapping_table: shows objects that 'lead to'
On 9/30/05, jan aerts (RI) [EMAIL PROTECTED] wrote:
Hi,
I'm having some problems in combining a function within a standard
query.
I basically have two tables (see between hashes below):
* alias_table: objects can have different names (e.g. name1 is an alias
of name2, and name3 is an alias