From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Robert Haas <robertmhaas(at)gmail(dot)com>, Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: [PERFORM] typoed column name, but postgres didn't grump |
Date: | 2010-11-04 16:48:08 |
Message-ID: | AANLkTikymqi_chTOgpUzmFfA_hCbEQLDwhaA7No_1hgq@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-performance |
On Thu, Nov 4, 2010 at 12:14 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
>> Merlin Moncure <mmoncure(at)gmail(dot)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
Actually I didn't -- I left out that there was a function f taking x.
I misunderstood your assertion above: "The notation t(x) will be taken
to mean x::t if there's no function t() taking x's type, but there is
a cast from x's type to t".
I thought you meant that it would no longer implicitly cast where it
used to for record types, rather than the expression rewrite it was
doing (it just clicked). Anyways, no objection to the change, or even
the backpatch if you'd like to do that. FWIW.
If we ever have an IOCCCish contest for postgresql variant of SQL,
there are some real gems in this thread :-).
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-11-04 16:49:28 | Re: [PERFORM] typoed column name, but postgres didn't grump |
Previous Message | Tom Lane | 2010-11-04 16:14:45 | Re: [PERFORM] typoed column name, but postgres didn't grump |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-11-04 16:49:28 | Re: [PERFORM] typoed column name, but postgres didn't grump |
Previous Message | Tom Lane | 2010-11-04 16:14:45 | Re: [PERFORM] typoed column name, but postgres didn't grump |