Postgres Pro
Downloads
Home   >   mailing lists

Re: Can't get upsert working. - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Can't get upsert working.
Date
Msg-id 50BDB625.2070800@archonet.com
Whole thread Raw
In response to Can't get upsert working.  (Bert <biertie@gmail.com>)
List pgsql-sql
Tree view 
On 30/11/12 17:00, Bert wrote:
> SELECT (ET.row1,
>     ET.row2,
>     ET.row3)

> But I always get this error message:
> ERROR:  column "row1" is of type integer but expression is of type record
> LINE 67: SELECT (ET.ROW1,
>
> Does anyone has an idea?

You've bracketed the SELECT colums above, which means it's trying to 
treat them as a single record-column with three fields. Hence the error 
message.

--  Richard Huxton  Archonet Ltd

pgsql-sql by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Can't get upsert working.
Next
From: Emi Lu
Date:
Subject: Load UTF8@psql into latin1@mysql through JDBC