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
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 |
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 |