RE: [HACKERS] implementing outer joins
| От | Stupor Genius |
|---|---|
| Тема | RE: [HACKERS] implementing outer joins |
| Дата | |
| Msg-id | 000101bda691$d5825880$c697accf@darren обсуждение исходный текст |
| Ответ на | implementing outer joins (Brett McCormick <brett@work.chicken.org>) |
| Список | pgsql-hackers |
> > does anyone have any idea how difficult it would be to implement, and > perhaps point me in the right direction? > I forget where, but there is a place in the code where the two values of the join are compared to see whether the row qualifies. Around this spot there is a check for one of the values being null and if it is, the function doesn't include the data. Seems that modifying that spot or using it as a basis for your code could be a quick start for the left join. The right could perhaps then be converted beforehand in the optimizer to a left to be handled there. But there's prolly a great and sane reason why this wouldn't work. Haven't thought about the full outer join yet. Don't have my machine completely configured yet and it's hard to stay in to do that with it being summer and all. Later, darrenk
В списке pgsql-hackers по дате отправления: