left outer join and values()
| От | Tom Allison |
|---|---|
| Тема | left outer join and values() |
| Дата | |
| Msg-id | 7AE17EF9-9209-4D4E-A55F-802DE5FDB0F3@tacocat.net обсуждение исходный текст |
| Ответы |
Re: left outer join and values()
|
| Список | pgsql-general |
I did something like this with a single VALUES statment [eg: VALUES
((2),(3))]
and thought I could extend this to two columns....
But I'm not having any luck.
BTW - history_idx is an integer and token_idx is a bigint.
select v.history.idx, v.token_idx
from (
values ((3,1),(3,2))) as v(history_idx, token_idx)
left outer join history_token ht on v.history_idx = ht.history_idx
and v.token_idx = ht.token_idx
where ht.history_idx is null;
ERROR: operator does not exist: record = integer
LINE 4: left outer join history_token ht on v.history_idx = ht.histo...
^
HINT: No operator matches the given name and argument type(s). You
may need to add explicit type casts.
NOTE: the '^' is pointing to the '=' on Line 4
В списке pgsql-general по дате отправления: