Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M36982=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1Tfnzw-0005Up-07
	for pgsql-sql@arkaria.postgresql.org; Tue, 04 Dec 2012 08:37:00 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M36982=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1Tfnzu-0006Zf-VP
	for pgsql-sql@arkaria.postgresql.org; Tue, 04 Dec 2012 08:36:59 +0000
Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <dev@archonet.com>) id 1Tfnzu-0006Za-9L
	for pgsql-sql@postgresql.org; Tue, 04 Dec 2012 08:36:58 +0000
Received: from archon2012.plus.com ([80.229.41.160] helo=mail.archonet.com)
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <dev@archonet.com>) id 1Tfnzs-0001ty-Pl
	for pgsql-sql@postgresql.org; Tue, 04 Dec 2012 08:36:57 +0000
Received: from [192.168.1.13] (ariel.office.archonet.com [192.168.1.13])
	by mail.archonet.com (Postfix) with ESMTP id 7ACB62C6839;
	Tue,  4 Dec 2012 08:36:53 +0000 (GMT)
Message-ID: <50BDB625.2070800@archonet.com>
Date: Tue, 04 Dec 2012 08:36:53 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:10.0.10) Gecko/20121027 Icedove/10.0.10
MIME-Version: 1.0
To: Bert <biertie@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: Can't get upsert working.
References: 
 <CAFCtE1=xUHzWQcpBQ7tSxFfQwJO-Pay2jFyfWHZ5dPDuAPhnEg@mail.gmail.com>
In-Reply-To: 
 <CAFCtE1=xUHzWQcpBQ7tSxFfQwJO-Pay2jFyfWHZ5dPDuAPhnEg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql