Re: [PERFORM] typoed column name, but postgres didn't grump

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PERFORM] typoed column name, but postgres didn't grump
Дата
Msg-id 9974.1288887285@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PERFORM] typoed column name, but postgres didn't grump  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: [PERFORM] typoed column name, but postgres didn't grump  (Merlin Moncure <mmoncure@gmail.com>)
Re: [PERFORM] typoed column name, but postgres didn't grump  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-bugs
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Merlin Moncure <mmoncure@gmail.com> wrote:
>> Trying to understand real world cases that this would
>> break...would the following now fail w/o explicit cast?
>>
>> create type x as (a int, b int);
>> select f((1,2));

> It already does:

I think Merlin probably meant to write "select x((1,2))", but that
doesn't work out-of-the-box either.  What would be affected is
something like

    select text((1,2));

which you'd now be forced to write as

    select (1,2)::text;

(or you could use CAST notation; but not text(row) or row.text).

            regards, tom lane

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: [PERFORM] typoed column name, but postgres didn't grump
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: [PERFORM] typoed column name, but postgres didn't grump