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

Reply via email to