From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Marko Kreen" <markokr(at)gmail(dot)com> |
Cc: | pgsql-patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: review: table function support |
Date: | 2008-07-10 08:58:18 |
Message-ID: | 162867790807100158j6461ee76g639367c0547ec3bf@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Hello,
I am sending actualized patch
Regards
Pavel Stehule
2008/7/9 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
> 2008/7/9 Marko Kreen <markokr(at)gmail(dot)com>:
>> Generally, the patch looks fine. There are few issues still:
>>
>> - plpgsql: the result columns _do_ create local variables.
>> AIUI, they should not?
>
> it was my mistake - it doesn't do local variables - fixed
>>
>> - pg_dump: is the psql_assert() introduction necessary, considering it
>> is used only in one place?
>
> removed - argmode variables is checked before
>>
>> - There should be regression test for plpgsql too, that test if
>> the behaviour is correct.
>>
>
> addeded
>> - The documentation should mention behaviour difference from OUT
>> parameters.
>
> I will do it.
>>
>> Wishlist (probably out of scope for this patch):
>
> this is in my wishlist too, but postgresql doesn't support types like
> result of functions.
>>
>> - plpgsql: a way to create record variable for result row. Something like:
>>
>> CREATE FUNCTION foo(..) RETURNS TABLE (..) AS $$
>> DECLARE
>> retval foo%ROWTYPE;
>>
>>
>> Currently the OUT parameters are quite painful to use due to bad
>> name resolving logic. Such feature would be perfect replacement.
>>
>> --
>> marko
>>
> I'll send patch early, thank you much
>
> Regards
> Pavel Stehule
>
Attachment | Content-Type | Size |
---|---|---|
tabfce1.1.diff | text/x-patch | 25.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2008-07-10 09:48:42 | Re: Auto-explain patch |
Previous Message | Richard Huxton | 2008-07-10 08:43:14 | Re: Security and Data Protection Issues |
From | Date | Subject | |
---|---|---|---|
Next Message | Abhijit Menon-Sen | 2008-07-10 10:42:34 | Re: WITH RECURSIVE updated to CVS TIP |
Previous Message | Simon Riggs | 2008-07-10 07:06:12 | Re: Sorting writes during checkpoint |