2010/9/24 André Fernandes <[email protected]>: > > >> Date: Fri, 24 Sep 2010 08:01:35 -0400 >> Subject: Re: [HACKERS] Name column >> From: [email protected] >> To: [email protected] >> CC: [email protected]; [email protected] >> >> On Fri, Sep 24, 2010 at 6:35 AM, Heikki Linnakangas >> <[email protected]> wrote: >> > For historical reasons PostgreSQL supports calling a function with a >> > single >> > argument like "column.function", in addition to "function(column)". >> > There is >> > a function "name(text)" that casts the input to the 'name' datatype, so >> > your >> > example casts the row to text and from text to name. >> >> I'm starting to wonder if we should think about deprecating this >> behavior. It is awfully confusing and unintuitive. >> > > I agree, it is very unintuitive. > +1 for deprecating this behavior.
+1 I dislike this feature too. It is breaking other ANSI SQL feature - constructors, because it has same syntax tablename(field1, field2, ....). Sure, usually we can do ROW(a,b,c)::type - but little bit nicer and with standard is type(a,b,c). Regards Pavel Stehule > -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
