Re: Proposal: stand-alone composite types - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Proposal: stand-alone composite types
Date
Msg-id 00fb01c24054$740bdc00$0200a8c0@SOL
Whole thread Raw
In response to Re: Proposal: stand-alone composite types  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> than to do:
>
>     CREATE TYPE some_arbitrary_name AS (f1 int, f2 text);
>     CREATE FUNCTION foo() RETURNS SETOF some_arbitrary_name;
>
> But I admit it is only a "nice-to-have", not a "need-to-have".
>
> How do others feel? Do we want to be able to implicitly create a
> composite type during function creation? Or is it unneeded bloat?
>
> I prefer the former, but don't have a strong argument against the latter.

The former is super sweet, but does require some extra catalog entries for
every procedure - but that's the DBA's problem.  They can always use the
latter syntax.  The format syntax is cool and easy and it Should Just Work
for newbies...

Chris




pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: pg_stat_reset() weirdness
Next
From: Tom Lane
Date:
Subject: Re: pg_stat_reset() weirdness