Hi,
One developer asked me about case-sensitive, if its possible disable
Postgres not consider when using comparative functions.
Eg.:
select * from people
where upper(name) like upper('A%');
Is there any parameter that don't take in account case-sensitive, or any
other way to treat??
Thanks
Hi,
On Thursday 25 January 2007 11:52, Alexander B. wrote:
| One developer asked me about case-sensitive, if its possible disable
| Postgres not consider when using comparative functions.
| Eg.:
| select * from people
| where upper(name) like upper('A%');
|
| Is there any parameter that don't take
'citext' module (http://gborg.postgresql.org/project/citext/projdisplay.php)
might help you with this
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/25/07, Alexander B. <[EMAIL PROTECTED]> wrote:
Hi,
One developer asked me about case-sensitive, if its possible disable
Pos
Campbell, Lance wrote:
I want to log all SQL commands as an executable script file for use in
performance testing. Currently there is a lot of information in the log
that is generated that would not be executable. Below is an example of
what I would want to see; which is just the SQL.
E
Look at pgfouine.
It can extract SQL commands from log, and build a xml file to be used
with tsung to generate some load testing.
Kind regards...
On 1/24/07, Campbell, Lance <[EMAIL PROTECTED]> wrote:
I want to log all SQL commands as an executable script file for use in
performance testin
And there is an FAQ about this.
---
Shoaib Mir wrote:
> 'citext' module (http://gborg.postgresql.org/project/citext/projdisplay.php)
> might help you with this
>
> ---
> Shoaib Mir
> EnterpriseDB (www.enterprise
On Thu, Jan 25, 2007 at 08:52:28 -0200,
"Alexander B." <[EMAIL PROTECTED]> wrote:
> Hi,
>
> One developer asked me about case-sensitive, if its possible disable
> Postgres not consider when using comparative functions.
> Eg.:
> select * from people
> where upper(name) like upper('A%');
>
> Is t
I actually wrote a java application that can strip out the SQL and build
a SQL script file.
If you take a snap shot of your database and then log the SQL commands
you have at least a real world snapshot of the SQL being executed for a
given time. This gives you some level of measurement when comp
