Populate Table From Two Other Tables

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Populate Table From Two Other Tables
Date: 2012-06-05 22:50:47
Message-ID: alpine.LNX.2.00.1206051542170.27613@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I want to combine columns in two tables and use the exported resulting
table for statistical analyses. The SQL script is:

INSERT INTO waterchem (site, sampdate, param, quant, ceneq1, low, high,
stream, basin)
SELECT c.site, c.sampdate, c.param, c.quant, c.ceneq1, c.low, c.high,
s.stream, s.basin
FROM chemistry as c, sites as s
WHERE c.site == s.siteid;

The problem is that both c.site and s.siteid are of type VARCHAR(16) and
postgres tells me,

ERROR: operator does not exist: character varying == character varying

and provides the hint to add explicit type casts. Since the string length of
site/siteid varies I don't see how to cast both to a working type.

Please suggest how I can populate this table while avoiding the operator
error.

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Williamson 2012-06-05 23:02:28 Re: Populate Table From Two Other Tables
Previous Message Dann Corbit 2012-06-05 22:36:52 Re: I'd like to learn a bit more about how indexes work