Re: Can't get upsert working.

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Can't get upsert working.
Дата
Msg-id 50BDB625.2070800@archonet.com
обсуждение исходный текст
Ответ на Can't get upsert working.  (Bert <biertie@gmail.com>)
Список 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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Can't get upsert working.
Следующее
От: Emi Lu
Дата:
Сообщение: Load UTF8@psql into latin1@mysql through JDBC