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 CAKFQuwYUMmWwRxC2Wk4R+HVPSxZxCxa7KdotWbksfbHHYk0mzw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Array string casts with SELECT but not SELECT DISTINCT  (Ken Tanzer <ken.tanzer@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Sat, Feb 21, 2015 at 7:11 PM, Ken Tanzer [via PostgreSQL] <[hidden email]> wrote:
I tried that and it does indeed work. (With, of course, the appropriate permissions to create the cast.)

So this makes me wonder--is there any downside or unwelcome side effects to having such a cast?  And if not, why isn't it part of the default setup?


​By and large implicit casts work great if you code everything without error.  When they become a problem is when you make mistakes and because of implicit casting instead of getting an error you get bogus results.

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
Следующее
От: Giuseppe Sacco
Дата:
Сообщение: Re: Postgres architecture for multiple instances