| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com> |
| Cc: | Chris Travers <chris(dot)travers(at)gmail(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Xtra Coder <xtracoder(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Any reasons for 'DO' statement not returning result? |
| Date: | 2016-08-16 19:59:43 |
| Message-ID: | CAFj8pRA+ghZe5WFspfoszRshvmWKeHZq9Mo7a8TjeDTXrsxggw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2016-08-16 21:50 GMT+02:00 Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>:
> On 8/16/16 11:17 AM, Chris Travers wrote:
>
>> I am thinking adding a temporary keyword to functions would make a lot
>> more sense.
>>
>
> Well, right now that's just syntactic sugar, so I think the only real
> benefit might be visibility (though, really we should be marketing the idea
> that you can create almost *any* object in pg_temp!).
>
> What would be a lot more interesting is if creating a temp function didn't
> involve writing an entry to the catalog (something being discussed for temp
> tables right now).
>
Oracle has interesting temporary function defined inside CTE
Pavel
> --
> Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
> Experts in Analytics, Data Architecture and PostgreSQL
> Data in Trouble? Get it in Treble! http://BlueTreble.com
> 855-TREBLE2 (855-873-2532) mobile: 512-569-9461
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2016-08-16 20:04:37 | Re: C++ port of Postgres |
| Previous Message | Jim Nasby | 2016-08-16 19:50:06 | Re: Any reasons for 'DO' statement not returning result? |