Re: [SQL] replicating a table in several databases

Hi，everybody.I am a new member. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe Sent: Wednesday, October 15, 2008 8:14 AM To: Chris Browne Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] replicating a table in several databases On Fri, Oct 1

Re: [SQL] replicating a table in several databases

On Fri, Oct 10, 2008 at 8:59 AM, Chris Browne <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] (Gerardo Herzig) writes: >> Hi all. Im facing a situation where i have to replicate a table from >> database A in databases B,C,F and so on. >> >> The first (and only) thing i have in mind is using triggers

Re: [SQL] effectiveness tool

On Tue, Oct 14, 2008 at 4:34 PM, Judith Altamirano <[EMAIL PROTECTED]> wrote: > Hello everybody!! > > I just want to know if there be some tool to analize the performance of a > query, I mean to qualify the effectiveness, speed, if I have the correct > indexes. Google pg fouine. -- Sent via pgs

Re: [SQL] effectiveness tool

On Tuesday 14 October 2008 3:34:53 pm Judith Altamirano wrote: > Hello everybody!! > >I just want to know if there be some tool to analize the performance > of a query, I mean to qualify the effectiveness, speed, if I have the > correct indexes. > >Hope somebody can help me > > Thanks

[SQL] effectiveness tool

Hello everybody!! I just want to know if there be some tool to analize the performance of a query, I mean to qualify the effectiveness, speed, if I have the correct indexes. Hope somebody can help me Thanks in advanced!! -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)

Re: [SQL] SELECT multiple MAX(id)s ?

> -Mensaje original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] En nombre de Aarni Ruuhimäki > Enviado el: Viernes, 10 de Octubre de 2008 07:56 > Para: pgsql-sql@postgresql.org > Asunto: [SQL] SELECT multiple MAX(id)s ? > > Hello list, > > table diary_entry > > entry_id SERI

Re: [SQL] EXISTS

Thanks to those who responded, I see PL/PgSQL is the way to go Regards, denis woodbury on 10/11/08 1:32 PM, [NAME] at [ADDRESS] wrote: > Denis Woodbury <[EMAIL PROTECTED]> writes: >> I would like to know if this this type of statement can be used in >> Postgresql > >> IF NOT EXISTS (SELECT 1

Re: [SQL] EXISTS

Denis Woodbury wrote: Hi, I would like to know if this this type of statement can be used in Postgresql IF NOT EXISTS (SELECT 1 FROM Table WHERE col1 = 'mystring' ) BEGIN ... END PostgreSQL doesn't have any sort of free block flow control; it doesn't have an IF statement or similar in SQL. Y