Re: [SQL] combination of function to simple query makes query slow

2005-10-04 Thread jan aerts (RI)
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 >

Re: [SQL] combination of function to simple query makes query slow

2005-10-03 Thread jan aerts (RI)
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

[SQL] combination of function to simple query makes query slow

2005-09-30 Thread jan aerts (RI)
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