Full outer join
От | Tim Perdue |
---|---|
Тема | Full outer join |
Дата | |
Msg-id | 20010412130950.O446@mail.perdue.net обсуждение исходный текст |
Ответы |
Re: Full outer join
Re: Full outer join |
Список | pgsql-sql |
Looking at the docs for 7.1, it appears that full outer joins are supported: http://www.postgresql.org/devel-corner/docs/user/queries.html However, I keep getting this error, and I don't know what it means: ERROR: FULL JOIN is only supported with mergejoinable join conditions I've tried several variations and keep getting the same error. Anyone have any ideas? Details below. Thanks, Tim SELECT * FROM (stats_http_downloads sh FULL OUTER JOIN stats_ftp_downloads sf USING (day,filerelease_id)) ; ERROR: FULL JOIN is only supported with mergejoinable join conditions SELECT day,filerelease_id FROM (stats_http_downloads sh FULL OUTER JOIN stats_ftp_downloads sf USING (day,filerelease_id)) ; ERROR: FULL JOIN is only supported with mergejoinable join conditions alexandria=# \d stats_http_downloads Table "stats_http_downloads" Attribute | Type | Modifier ----------------+---------+----------------------day | integer | not null default '0'filerelease_id | integer| not null default '0'group_id | integer | not null default '0'downloads | integer | not null default '0' alexandria=# \d stats_ftp_downloads Table "stats_ftp_downloads" Attribute | Type | Modifier ----------------+---------+----------------------day | integer | not null default '0'filerelease_id | integer| not null default '0'group_id | integer | not null default '0'downloads | integer | not null default '0' -- Founder - PHPBuilder.com / Geocrawler.com Lead Developer - SourceForge VA Linux Systems
В списке pgsql-sql по дате отправления: