"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
ny additional suggestions?
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:
> 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
MAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of jan 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 combini
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
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' oth
