Thank you for the response.
I did figure this out a few minutes after I sent this post.
Apologies for jumping the gun.
I must say, I am absolutely impressed with what pgsql's
implimentation of VALUES allows me to do.
It's kind of ridiculous how much "work" goes away in my code.
Too bad I c
Tom Allison <[EMAIL PROTECTED]> writes:
> 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
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_
