View Single Post

   
  #6 (permalink)  
Old 04-17-2008, 08:13 PM
Guillaume Lelarge
 
Posts: n/a
Default Re: Not able to add or remove argument in Parameterstab, Function Properties

Dave Page a écrit :
> Guillaume Lelarge wrote:
>> Dave Page a écrit :
>>> Guillaume Lelarge wrote:
>>>> zoran a écrit :
>>>>> Hi,
>>>>>
>>>>> Do buttons Add and Remove in Parameters tab have purpose?
>>>>>
>>>> They have when you're connected to a PostgreSQL 8.3 server.
>>>>
>>>> Dave, do you think we should hide the parameters' tab when used with
>>>> pre-8.3 servers ? I can write a patch for this.
>>> No - parameters are used in all versions of PostgreSQL. You can only
>>> add/remove them when creating the function though, not when editing it
>>> (because that would change the signature, thus making it a new function).
>>>

>> I thought it was an 8.3 new feature ?

>
> eh?
>
> You cannot change foo(int, int) to foo(int, int, int) because it would
> become a whole new function. Thus you can only add/remove parameters at
> initial design time.
>


OK, we're not talking about the same thing. I was referring to session
parameters that can be added to functions in 8.3

Now that I re-read the mail subject, my answer was completely wrong.

Sorry about his.


--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote