From: | Tom Allison <tom(at)tacocat(dot)net> |
---|---|
To: | General PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
Subject: | left outer join and values() |
Date: | 2007-05-31 23:44:55 |
Message-ID: | 7AE17EF9-9209-4D4E-A55F-802DE5FDB0F3@tacocat.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas | 2007-06-01 01:01:08 | where find recent binary PostgreSQL |
Previous Message | Ottavio Campana | 2007-05-31 23:37:29 | Re: shut down one database? |