left outer join and values()

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

Responses

Browse pgsql-general by date

  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?