Re: Proposal: stand-alone composite types

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Joe Conway" <mail(at)joeconway(dot)com>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal: stand-alone composite types
Date: 2002-08-10 09:58:17
Message-ID: 00fb01c24054$740bdc00$0200a8c0@SOL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

> 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff MacDonald 2002-08-10 12:17:28 Re: I am being interviewed by OReilly
Previous Message Christopher Kings-Lynne 2002-08-10 09:52:47 Re: pg_stat_reset() weirdness

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-08-10 19:58:54 Re: small psql patch - show Schema name for \dt \dv \dS
Previous Message Tatsuo Ishii 2002-08-10 06:51:26 Re: [GENERAL] workaround for lack of REPLACE() function