Re: [GENERAL] Hash join operator question

2005-05-23 Thread Tom Lane
Paolo Tavalazzi <[EMAIL PROTECTED]> writes: > My feeling is that having to only confront the value key venue_code with a > variable value and a constant value "*", > it can be possible to create an operator that it manages this type of query > using a hashjoin clause. > Is it possible?? No.

[GENERAL] Hash join operator question

2005-05-23 Thread Paolo Tavalazzi
I'd like to understand if it is possible to find a solution to the problem that we have on ours DB in production.   I make an example simplified in order to explain itself better:   We have 2 table :   TABLE vendor ( group TEXT, client TEXT, vdr_venue_code CHAR(8), vdr_location_code CHAR(8))

[GENERAL] Hash join operator question

2005-05-23 Thread Paolo Tavalazzi
I'd like to understand if it is possible to find a solution to the problem that we have on ours DB in production. I make an example simplified in order to explain itself better: We have 2 table : TABLE vendor ( group TEXT, client TEXT, vdr_venue_code CHAR(8), vdr_location_code CHAR(8) )