Hi,
# psql83 template1
Password:
Welcome to psql83 8.3.5, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
template1=#
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
Pavel Stehule wrote:
> I am sending patch, that adds FOUND and GET DIAGNOSTICS support for
> RETURN QUERY statement
Updated patch attached and applied. Thanks.
---
>
> Regards
> Pavel Stehule
>
>
>
> 2008/11/10 Andrew
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
On Thu, Feb 05, 2009 at 12:11:51PM +, Eduard Deacoon wrote:
> WHERE '' || QUOTE_IDENT($3) || '' = '' ||
> $4||''::TEXT'' ||
make it:
WHERE '' || QUOTE_IDENT($3) || '' = '' ||
quote_literal($4)||''::TEXT'' ||
Best regards,
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: htt
The following bug has been logged online:
Bug reference: 4642
Logged by: Eduard Deacoon
Email address: d...@yandex.ru
PostgreSQL version: all
Operating system: FreeBSD
Description:EXECUTE work incorrect
Details:
Hi!
EXECUTE work incorrect if one or more string have
The following bug has been logged online:
Bug reference: 4641
Logged by: Adrian Sandor
Email address: adi...@yahoo.com
PostgreSQL version: 8.3.5
Operating system: Linux
Description:Wrong estimates for multi-column conditions
Details:
I have two queries that should 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