Horton

Re: Can't get upsert working.

Richard Huxton <dev@archonet.com>

View thread View on postgr.es
From: Richard Huxton <dev@archonet.com>
To: Bert <biertie@gmail.com>
Cc: pgsql-sql@postgresql.org
Date: 2012-12-04T08:36:53Z
Lists: pgsql-sql 
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