Re: Array string casts with SELECT but not SELECT DISTINCT

Поиск
Список
Период
Сортировка
От David G Johnston
Тема Re: Array string casts with SELECT but not SELECT DISTINCT
Дата
Msg-id CAKFQuwYBu6cwaLmsM8qLeEYoxpLxC_BGLE2cXmBfmUMymihK5Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Array string casts with SELECT but not SELECT DISTINCT  (sridhar bamandlapally <sridhar.bn1@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Fri, Feb 20, 2015 at 7:31 PM, sridhar bamandlapally [via PostgreSQL] <[hidden email]> wrote:
>>>ERROR:  column "my_array" is of type character varying[] but expression is of type text

please try this below, may be this should help

CREATE CAST (text AS varchar) WITH INOUT AS IMPLICIT;

just for info:
actually this should be available in default


​What is the point of doing this?  Did you do this and then run the OP's query and see if it solved the problem?  Do you understand the "type[]" means "array version of type"?

David J.​
 

View this message in context: Re: Array string casts with SELECT but not SELECT DISTINCT
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

Предыдущее
От: sridhar bamandlapally
Дата:
Сообщение: Re: Array string casts with SELECT but not SELECT DISTINCT
Следующее
От: Ken Tanzer
Дата:
Сообщение: Re: Array string casts with SELECT but not SELECT DISTINCT