On Thu, 5 Feb 2009, Eduard Deacoon wrote:
> For example:
> --- Function convert column to string with delimiter
> --- $1 - TABLE with COLUMN to convert
> --- $2 - COLUMN to convert
> --- $3 - COLUMN for WHERE CLAUSE
> --- $4 - WHERE value
> --- $5 - delimeter
> --- In fact: SELECT $2 FROM $1 WHERE
05.02.09, 17:16, "Gregory Stark" :
> "Eduard Deacoon" writes:
> > If $4 has leading zero it does`n work :(
> please expand on "doesn't work"
> > Context replace with ''0 || '' || $4 work only if $4 have one leading zero.
> > ''00 || '' || $4 does`n work, ''0 || 0 ||'' || $4 - work
> I'm sorry I
"Eduard Deacoon" writes:
> If $4 has leading zero it does`n work :(
please expand on "doesn't work"
> Context replace with ''0 || '' || $4 work only if $4 have one leading zero.
> ''00 || '' || $4 does`n work, ''0 || 0 ||'' || $4 - work
I'm sorry I'm not following this part. What parameters d
The following bug has been logged online:
Bug reference: 4640
Logged by: Eduard Deacoon
Email address: d...@yandex.ru
PostgreSQL version: all
Operating system: FreeBSD
Description:Drop leading zero in EXECUTE
Details:
Hi!
EXECUTE has incorrect if one or more string