[SQL] Database Synchronization

2007-07-18 Thread Jyoti Seth
Hello , I have two postgres databases on different linux servers. Postgres database on one server has some tables that needs to be synchronized from the other postgres database . What should be the best method for this. Please let me know if someone has idea. Thanks, Jyoti Seth

Re: [SQL] Database Synchronization

2007-07-18 Thread Richard Huxton
Jyoti Seth wrote: Hello , I have two postgres databases on different linux servers. Postgres database on one server has some tables that needs to be synchronized from the other postgres database . What should be the best method for this. The slony replication package lets you choose what t

[SQL] Birth Day Calculation

2007-07-18 Thread Ashish Karalkar
Hello All, I want to diplay all the name of persons who falls in between given day and month something like select name from my_table mt where mt.date_of_birth between 7-Jul and 15 - Aug column date_of_birth is of date type is there any way to do this Thanks in advance Ashish...

Re: [SQL] Inserting an IF statement in the middle of a SELECT in pl/pgSQL code

2007-07-18 Thread Fernando Hevia
You should try 'Coalesce' function. By the way, your "incident_date-to-quarter" expression could be shortened: SELECT DISTINCT(pi.serial_number) AS "Incident ID", to_char(pi.incident_date,'Mon-dd-') AS "Incident date", to_char(pi.date_created,'Mon-dd-') AS "Report Date", (((EXTRACT (M

Re: [SQL] Birth Day Calculation

2007-07-18 Thread Osvaldo Rosario Kussama
Ashish Karalkar escreveu: Hello All, I want to diplay all the name of persons who falls in between given day and month something like select name from my_table mt where mt.date_of_birth between 7-Jul and 15 - Aug column date_of_birth is of date type SELECT name FROM my_table mt

Re: [SQL] Database Synchronization

2007-07-18 Thread Chris Browne
[EMAIL PROTECTED] (Richard Huxton) writes: > Jyoti Seth wrote: >> Hello , >> I have two postgres databases on different linux servers. Postgres >> database >> on one server has some tables that needs to be synchronized from the other >> postgres database . What should be the best method for this.

Re: [SQL] Database Synchronization

2007-07-18 Thread Richard Huxton
Chris Browne wrote: [EMAIL PROTECTED] (Richard Huxton) writes: http://www.slony.info/ But it is worth noting one thing about the synchronization... Slony-I's strategy is pretty simple: One node is considered the "master," and the other node is forcibly made to conform to what is on the mast

[SQL] pgmemcache

2007-07-18 Thread PostgreSQL Admin
As anyone used pgmemcache? I would like to look more into a but I'm having problems installing the sql. I'm on OS X 10.4 and the sql there are lines causing errors: (e.g. AS '$libdir/pgmemcache', 'memcache_server_add' LANGUAGE 'C' STRICT;) thanks for any input and also will version 1.2 come

Re: [SQL] Inserting an IF statement in the middle of a SELECT in pl/pgSQL code

2007-07-18 Thread Jaime Casanova
sorry, i resubmit to the list On 7/18/07, Jaime Casanova <[EMAIL PROTECTED]> wrote: On 7/18/07, Norm Garand <[EMAIL PROTECTED]> wrote: > Thanks Jaime: > > I tried using the CASE function and it still didn't work. > > What I need to do is set a conditional, so that if the parameter is NULL, then

Re: [SQL] Database Synchronization

2007-07-18 Thread Jyoti Seth
Thanks a lot for your suggestions. I have ony single master. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Huxton Sent: Wednesday, July 18, 2007 9:13 PM To: Chris Browne Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Database Synchronization Ch