Re: [HACKERS] wishlist for 8.4

2008-02-18 Thread James Mansion
Richard Huxton wrote: It would be nice to have a more dynamic language built-in. I'm not aware of any BSD-licensed dynamic languages though. Lua is MIT. And I believe there's even a pl/Lua around. The small size of the interpreter and ease of C interfacing would make it ideal, or at least i

Re: [HACKERS] wishlist for 8.4

2008-02-15 Thread David Fetter
On Fri, Feb 15, 2008 at 10:06:49AM +, Richard Huxton wrote: > Decibel! wrote: >> On Feb 14, 2008, at 10:06 AM, Tom Lane wrote: >>> =?UTF-8?B?UmFwaGHDq2wgSmFjcXVvdA==?= <[EMAIL PROTECTED]> writes: so, I propose the use of NEW[variable_containing_the_column_name] (which can obv

Re: [HACKERS] wishlist for 8.4

2008-02-15 Thread Heikki Linnakangas
Raphaël Jacquot wrote: I recently found myself trying to build a trigger to modify some fields in a good dozen similarly structured tables in which the similar columns had different names. in fact, I got stuck in pl/pgsql with the fact that there's no way to access the NEW tuple in an indirect

Re: [HACKERS] wishlist for 8.4

2008-02-15 Thread Sam Mason
On Thu, Feb 14, 2008 at 11:06:42AM -0500, Tom Lane wrote: > =?UTF-8?B?UmFwaGHDq2wgSmFjcXVvdA==?= <[EMAIL PROTECTED]> writes: > > so, I propose the use of > > NEW[variable_containing_the_column_name] > > (which can obviously be extended to any tuples) > > to allow such access. > > > what do you

Re: [HACKERS] wishlist for 8.4

2008-02-15 Thread Richard Huxton
Decibel! wrote: On Feb 14, 2008, at 10:06 AM, Tom Lane wrote: =?UTF-8?B?UmFwaGHDq2wgSmFjcXVvdA==?= <[EMAIL PROTECTED]> writes: so, I propose the use of NEW[variable_containing_the_column_name] (which can obviously be extended to any tuples) to allow such access. what do you experts think

Re: [HACKERS] wishlist for 8.4

2008-02-14 Thread Decibel!
On Feb 14, 2008, at 10:06 AM, Tom Lane wrote: =?UTF-8?B?UmFwaGHDq2wgSmFjcXVvdA==?= <[EMAIL PROTECTED]> writes: so, I propose the use of NEW[variable_containing_the_column_name] (which can obviously be extended to any tuples) to allow such access. what do you experts think ? Zero cha

Re: [HACKERS] wishlist for 8.4

2008-02-14 Thread Tom Lane
=?UTF-8?B?UmFwaGHDq2wgSmFjcXVvdA==?= <[EMAIL PROTECTED]> writes: > so, I propose the use of > NEW[variable_containing_the_column_name] > (which can obviously be extended to any tuples) > to allow such access. > what do you experts think ? Zero chance. plplgsql is a strongly typed language,

Re: [HACKERS] wishlist for 8.4

2008-02-14 Thread Martijn van Oosterhout
On Thu, Feb 14, 2008 at 07:51:31AM +0100, Raphaël Jacquot wrote: > in fact, I got stuck in pl/pgsql with the fact that there's no way to > access the NEW tuple in an indirect way, having the name of the column > in some variable. (I found that it could be done in plperl, but that > left me with