On 06/13/2014 03:42 PM, Ian Barwick wrote:
Hi
On 14/06/13 16:20, Quan Zongliang wrote:
Hi all,
Please find the attachment.
By my friend asking, for convenience,
support to define multi variables in single PL/pgSQL line.
Like this:
CREATE OR REPLACE FUNCTION try_mutlivardef() RETURNS text
|| local_b || local_c;
end;
$$ LANGUAGE plpgsql;
Regards,
Quan Zongliang
---
此电子邮件没有病毒和恶意软件，因为 avast! 防病毒保护处于活动状态。
http://www.avast.com
diff --git a/src/pl/plpgsql/src/pl_gram.y b/src/pl/plpgsql/src/pl_gram.y
index e3a992c..2737a3a 100644
--- a/src/pl/plpgsql/src/pl_gram.y
+++ b/src/pl/plpgsql/src
On 09/06/2013 01:02 AM, Robert Haas wrote:
On Wed, Sep 4, 2013 at 11:02 PM, Quan Zongliang wrote:
I think of a new idea.
Add a compare method column to pg_collation.
Every collation has its own compare function or null.
When function varstr_cmp is called, if specified collation
has compare
l it instead of strcoll().
How about this?
Regards.
Quan Zongliang
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On 07/23/2013 09:42 PM, Craig Ringer wrote:
(Replying on phone, please forgive bad quoting)
Isn't this pretty much what adopting ICU is supposed to give us? OS-independent
collations?
Yes, we need OS-independent collations.
I'd be interested in seeing the rest data for this performance repo
On 07/22/2013 03:54 PM, Craig Ringer wrote:
On 07/22/2013 12:17 PM, Quan Zongliang wrote:
Hi hackers,
I tried to improve performance when database is Chinese.
Under openSUSE, create index on table with 54996 rows
locale=C, 140ms
locale=zh_CN, 985ms
I think the function strcoll() of Linux is
On 2012/6/18 7:13, Peter Eisentraut wrote:
On lör, 2012-06-16 at 16:21 +0800, Quan Zongliang wrote:
I found that lower case is less than upper case when the db is
created
with utf8.
I tried below
locale en_US.utf8 'A'<'a' false
locale ja_JP.
7;a' false
Under Windows
locale Chinese_China 'A'<'a' false
I am not sure it is normal or not.
But in Chinese, the lower case should be greater than upper, same as
locale C.
I made some code try to fix it.
It seems to work fine.
Quan Zongliang
-
ly Bruce Momjian is now working on a different fix:
> > unix_socket_directory would be added to postmaster.pid, allowing pg_ctl
> > to find it.
>
> Yes, I will apply this patch tomorrow and it will be in 9.1. Thanks for
> the report.
>
Nice work.
--
Quan Zongliang
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
onfig option.
>
Sorry for my late reply.
I will check the source of postmaster.
--
Quan Zongliang
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
quot;createdb: createdb.o ... keywords.o"
Now it is "createdb: createdb.o ... keywords.o | submake-libpq"
How to do this?
--
SEARCHING JOB. I can work on C/C++.
Quan Zongliang
diff --git a/src/bin/pg_ctl/pg_ctl.c b/src/bin/pg_ctl/pg_ctl.c
old mode 10064
Which files need be modified?
sgml, html, and man-page or only sgml?
I am not familiar with this.
On Sun, 22 Aug 2010 08:25:59 -0700
David Fetter wrote:
> On Sun, Aug 22, 2010 at 10:03:32PM +0800, Quan Zongliang wrote:
> > Sure, I agree.
> > New patch attached. How about thi
Sure, I agree.
New patch attached. How about this?
On Fri, 20 Aug 2010 11:21:18 +0200
Magnus Hagander wrote:
> On Fri, Aug 20, 2010 at 01:01, Quan Zongliang wrote:
> > Because Windows's CreateService has serial start-type:
> > SERVICE_AUTO_START
> > SERVICE_BOOT_STAR
I don't know how to edit documents exactly before.
Thanks.
On Thu, 19 Aug 2010 08:48:53 -0700
David Fetter wrote:
> On Thu, Aug 19, 2010 at 10:24:54PM +0800, Quan Zongliang wrote:
> > documents attached. html and man-page
>
> Thanks!
>
> For future reference, t
h enclosed. Now in context format :)
>
> Thanks.
>
> Another thing -- why is there an enum at all? Seems it'd be
> simpler to assign the right value to the variable in the getopt() code
> to start with.
>
> --
> Álvaro Herrera
> The PostgreSQL Company - Comman
Sorry.
I forget to attach the patch file.
Begin forwarded message:
Date: Mon, 16 Aug 2010 19:49:20 +0800
From: Quan Zongliang
To: pgsql-hackers@postgresql.org
Subject: patch for pg_ctl.c to add windows service start-type
Hi, all
I modified pg_ctl.c to add a new option for Windows service
ERVICE_AUTO_START or SERVICE_DEMAND_START
respectively.
regards
--
Quan Zongliang
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
17 matches
Mail list logo
