Re: [BUGS] BUG #4640: Drop leading zero in EXECUTE

2009-02-05 Thread Stephan Szabo
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

Re: [BUGS] BUG #4640: Drop leading zero in EXECUTE

2009-02-05 Thread Дикун Эдуард
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

Re: [BUGS] BUG #4640: Drop leading zero in EXECUTE

2009-02-05 Thread 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'm not following this part. What parameters d

[BUGS] BUG #4640: Drop leading zero in EXECUTE

2009-02-05 Thread Eduard Deacoon
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