Re: Proposal: stand-alone composite types

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Proposal: stand-alone composite types
Дата
Msg-id 00fb01c24054$740bdc00$0200a8c0@SOL
обсуждение исходный текст
Ответ на Re: Proposal: stand-alone composite types  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: pg_stat_reset() weirdness
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_stat_reset() weirdness