On 10/26/05, Richard Huxton wrote:
> Rajesh Kumar Mallah wrote:
> > Hi,
> >
> > Can anyone tell me how to convert epoch to timestamp ?
> >
> > ie reverse of :
> >
> > SELECT EXTRACT( epoch FROM now() );
>
> I'd start with either Google or the manuals.
>
> http://www.postgresql.org/docs/8.0/intera
At 02:00 PM 10/27/05, Abhishek wrote:
I have a table "TABLE1" which has
Callguid | digits | type
123 'a'
345
On 10/27/05, Abhishek <[EMAIL PROTECTED]> wrote:
> I am tryng to write a query which returns me a record like this
> I do the query as this:
>
> select callguid , ( select digits from TABEL1 where type='a' ), ( select
> digits from TABEL1 where type='b' ), ( select digits from TABEL1 where
> type=
Hi.
Is there a way to references dynamic tables? I.E:
I have a table called "buy" that create some records in "financial" table, but
there is other table called "send" that create other records in "financial".
"Financial" table have the moneys' movements and needs to be referenciable by
"buy or sen
Thank you, and sorry for the late answer, I was far away from a decent
internet connection...
I'll try both your solutions, EXPLAIN ANALYSE will elect the winner... In
any case that will be cleaner than my dirty hack (2 distinct queries) which
generate a lot of garbage...
Thanks again,
MaXX
Dary
On Thu, Oct 27, 2005 at 02:21:15PM +0100, Richard Huxton wrote:
> So - if your statement contains something non-deterministic that isn't
> catered for in Mysql's code then it will break.
>
> At it's simplest - if I write a function my_random() and then do:
> UPDATE foo SET a=1 WHERE b < my_rand
Hi Everyone
I have a table "TABLE1" which has
Callguid | digits | type
123 'a'
345 'b'
Have you taken a look at
http://www.postgresql.org/docs/8.0/interactive/performance-tips.html ?
On Thu, Oct 27, 2005 at 03:03:36PM +0800, Abdul Wahab Dahalan wrote:
> Hi everyone!
>
> I'm looking for solution to speed up the database query, means that to get
> resultset as quicker as we can.
>
On 10/27/2005 8:34 AM, Mario Splivalo wrote:
Postgres itself offers no replication.
Oracle itself offers no replication.
IBM DB2 itself offers no replication.
Yet most of the products out there for Oracle, DB2 and PostgreSQL are
far better than what I read here:
http://dev.mysql.com/do
On Thu, Oct 27, 2005 at 15:03:36 +0800,
Abdul Wahab Dahalan <[EMAIL PROTECTED]> wrote:
> Hi everyone!
>
> I'm looking for solution to speed up the database query, means that to get
> resultset as quicker as we can.
>
> For example if I've 700 records in the table it will take longer time
> co
On Thu, Oct 27, 2005 at 02:34:13PM +0200, Mario Splivalo wrote:
>
> Postgres itself offers no replication. You could achive some sort of
> replication by restoring the parts of WAL files, but that's rather
> inconvinient. Then, if you want to replicate your data in any way, you
Well, AFAIK Oracle
The SQL data type "money" in postgreSQL was deprecated several versions
ago... however -- it is still available in the system. The definitions is:
CREATE TYPE money
(INPUT=cash_in, OUTPUT=cash_out, DEFAULT='',
INTERNALLENGTH=4, ALIGNMENT=int4, STORAGE=PLAIN);
ALTER TYPE money OWNER TO p
unsuscribe
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
On 10/27/2005 4:22 AM, Mario Splivalo wrote:
I see no point in blatantly putting 'other' products such shape. Pgsql
offers no replication at all, you need to use slony (wich is also a poor
replacement for a wannabe replication), or some other commercial
products. What about 2PC? What about linki
On 10/27/2005 4:22 AM, Mario Splivalo wrote:
On Wed, 2005-10-26 at 12:09 -0400, Jan Wieck wrote:
>
You must have missed the FAQ and other side notes about replication in
the MySQL manual. Essentially MySQL replication is nothing but a query
duplicating system, with the added sugar of taking
Mario Splivalo wrote:
On Wed, 2005-10-26 at 12:09 -0400, Jan Wieck wrote:
You must have missed the FAQ and other side notes about replication in
the MySQL manual. Essentially MySQL replication is nothing but a query
duplicating system, with the added sugar of taking care of now() and
some oth
On Thu, 2005-10-27 at 06:21 -0400, Andrew Sullivan wrote:
> On Thu, Oct 27, 2005 at 10:22:41AM +0200, Mario Splivalo wrote:
> > offers no replication at all, you need to use slony (wich is also a poor
> > replacement for a wannabe replication), or some other commercial
> > products. What about 2PC?
Thanks a lot, that worked for me!
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 27, 2005 2:47 PM
To: Wadhwa, Amit
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Complex Query - Data from 3 tables simultaneously
[EMAIL PROTECTED] wrote:
>
>
On Thu, Oct 27, 2005 at 10:22:41AM +0200, Mario Splivalo wrote:
> offers no replication at all, you need to use slony (wich is also a poor
> replacement for a wannabe replication), or some other commercial
> products. What about 2PC? What about linking the databases from
Slony is in fact a communi
[EMAIL PROTECTED] wrote:
Basically I want a raw dump of data
- Should have all the shipments regardless of whether they have any
material items entered or not
- Should have all Material Items for Every Shipment regardless of
whether it was issued or not.
I know I need an outer join (Do I Not?
padmanabha konkodi wrote:
hello developers,
i have facing one major problem handling sql money dataType in the
java
i have tried many permutation and combination but still i dint got
correct data type to use in java to pass money data
Have you tried PG's "numeric" type? What problems did you
On Wed, 2005-10-26 at 10:19 -0500, Scott Marlowe wrote:
> But, the next time someone says that slony is a toy add on, and MySQL
> has REAL replication, point them to THIS page on the same blog:
>
> http://ebergen.net/wordpress/?p=70
>
> In short, it basically shows that MySQL replication is incr
On Wed, 2005-10-26 at 12:09 -0400, Jan Wieck wrote:
> >
>
> You must have missed the FAQ and other side notes about replication in
> the MySQL manual. Essentially MySQL replication is nothing but a query
> duplicating system, with the added sugar of taking care of now() and
> some other non-de
Run an analyse on your query, create your indexes according to that, and
you have a better performing query.
Getting a resultset display faster will depend on your driver/RAM/client
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Abdul Wahab Dahalan
Sent:
Of course as long as your table increases its records, the longer will take
your query.
I think what you want is to minimize the run time even though you have large
tables. You should fine tune your database server (which I am still looking
for the best configuration for my server haha). And get t
Abdul Wahab Dahalan <[EMAIL PROTECTED]> schrieb:
> Hi everyone!
>
> I'm looking for solution to speed up the database query, means that to
> get resultset as quicker as we can.
09:41 < akretschmer> ??tuning
09:41 < rtfm_please> For information about tuning
09:41 < rtfm_please> see http://www.pow
All,
Using Postgres 8.0 on Windows Server 2003 - 16GB Ram,
3Ghz X 2 Xeons
Accessing through JDBC / JSP
I have 3 shipment tables.
Table A - Records arrived
Shipments.
Table B - Records Materials (maybe more than one per
shipment) in the shipment.
Table C - Records Issuances of material (
Hi everyone!
I'm looking for solution to speed up the database query, means that to get
resultset as quicker as we can.
For example if I've 700 records in the table it will take longer time compared
if I've only 20 records. How do we speed up the query?. Any query technique
that can be applied
28 matches
Mail list logo
