On Mon, Oct 7, 2013 at 10:35 PM, Kevin Grittner wrote:
> Aftab Ahmed Chandio wrote:
>
>> My query processes from JDBC (Java Program) to PostgreSQL. I use
>> system time by invoking java function, I collect one time unit
>> before the query statement perform and second after the execution
>> of qu
On Tue, Oct 8, 2013 at 3:48 AM, Aftab Ahmed Chandio wrote:
> What do u suggest me, where I need to make performance tuning? w hich
> configuration setting must need to modify in the linux?
Well, others have already pointed out that you should first measure
your query on the server. I would point
On 10/7/2013 6:48 PM, Aftab Ahmed Chandio wrote:
I found 85 ms time unit in DOS (win7) (laptop 4cores). both Java and
PostgreSQL installed and invoked on the same machine, respectively.
On the other hand, I use same process (separate installation) on linux
on 8 cores physical machine with 2times
Aftab Ahmed Chandio wrote:
> My query processes from JDBC (Java Program) to PostgreSQL. I use
> system time by invoking java function, I collect one time unit
> before the query statement perform and second after the execution
> of query statement.
> I found 85 ms time unit in DOS (win7) (laptop
Hi,
I want to know the reason behind the case:
My query processes from JDBC (Java Program) to PostgreSQL. I use system time by
invoking java function, I collect one time unit before the query statement
perform and second after the execution of query statement.
I found 85 ms time unit in DOS (win
i have tried in that way but its showing that the debit column doesn't exist
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgresql-query-tp5759846p5760593.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general maili
i am using postgresql 8.4 version..but this doesn't support the function
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgresql-query-tp5759846p5760589.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing l
Jashaswee wrote
> i have tried in that way but its showing that the debit column doesn't
> exist
So show us what exactly it is that you tried and maybe someone can tell you
what is wrong.
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgresql-query-tp575
Jashaswee wrote
> I have numeric values in a numeric column.the column has two parts.i want
> to split in 2 differnet column .
> The column value looks like this:
>
> Quantity
> 2000
> -1000
>
> both the quantity values are of a same product.but i want these in a
> single line.
> so what i wan
2013/6/19 Jashaswee
> The column value looks like this:
>
> Quantity
> 2000
> -1000
>
> both the quantity values are of a same product.but i want these in a
> single
> line.
> so what i want is a result set that looks like:
> In quantity Out quantity
> ---
> 2000
Which version of Postgresql are you using?
However, you may use string_agg like below if its available in your version:
\d t1
Table "public.t1"
Column | Type | Modifiers
+-+---
i | integer |
amt| integer |
select * from t1;
i | amt
---+-
1 | 2
I have numeric values in a numeric column.the column has two parts.i want to
split in 2 differnet column .
The column value looks like this:
Quantity
2000
-1000
both the quantity values are of a same product.but i want these in a single
line.
so what i want is a result set that looks like:
In
On Tue, 23 Sep 2003, shreedhar wrote:
> If I try to delete a record from my table which is giving following error
>
>
> Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in
> /xxx/database.inc on line 73
>
> What might be the problem.
Looks like line 73 of your /xxx/database
On Tue, 2003-09-23 at 05:57, shreedhar wrote:
> If I try to delete a record from my table which is giving following error
>
>
> Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in
> /xxx/database.inc on line 73
>
> What might be the problem.
What version are you running?
Co
If I try to delete a record from my table which is giving following error
Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in
/xxx/database.inc on line 73
What might be the problem.
Regards,
Sreedhar Bhaskararaju
---(end of broadcast)---
15 matches
Mail list logo
