Re: [BUGS] BUG #3428: plperl spi_exec_prepared char length always unity

2007-07-05 Thread Tom Lane
Matt Taylor <[EMAIL PROTECTED]> writes: > On Thu, 2007-07-05 at 00:13 -0400, Tom Lane wrote: >> IIRC, "char" means "char(1)" by default, so I'm unconvinced that this >> behavior is a bug. > Since 'character' is not accepted as a valid type by spi_prepare, is > this bug a duplicate of BUG #2917? M

Re: [BUGS] BUG #3428: plperl spi_exec_prepared char length always unity

2007-07-05 Thread Matt Taylor
On Thu, 2007-07-05 at 00:13 -0400, Tom Lane wrote: > "Matt Taylor" <[EMAIL PROTECTED]> writes: > > The spi_prepare and spi_exec_prepared doesn't seem to properly handle fixed > > character types. Only the first character of a string is passed to the > > database. > > IIRC, "char" means "char(1)

Re: [BUGS] BUG #3428: plperl spi_exec_prepared char length always unity

2007-07-04 Thread Tom Lane
"Matt Taylor" <[EMAIL PROTECTED]> writes: > The spi_prepare and spi_exec_prepared doesn't seem to properly handle fixed > character types. Only the first character of a string is passed to the > database. IIRC, "char" means "char(1)" by default, so I'm unconvinced that this behavior is a bug.

[BUGS] BUG #3428: plperl spi_exec_prepared char length always unity

2007-07-04 Thread Matt Taylor
The following bug has been logged online: Bug reference: 3428 Logged by: Matt Taylor Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Gentoo Description:plperl spi_exec_prepared char length always unity Details: The spi_prepare and spi_ex