Skip site navigation (1) Skip section navigation (2)

Re: Replace usage of a table in query with its array values

From: "Loredana Curugiu" <loredana(dot)curugiu(at)gmail(dot)com>
To: "Guy Rouillier" <guyr-ml1(at)burntmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Replace usage of a table in query with its array values
Date: 2007-07-02 16:49:54
Message-ID: 1c23c8e70707020949l3f6112dfra9e89467080b136e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-novicepgsql-sql
On 7/2/07, Guy Rouillier <guyr-ml1(at)burntmail(dot)com> wrote:
>
> Loredana Curugiu wrote:
> > After database redesign it was decided that reminder_services table
> > to be moved into another database. In production, reminder_services
> > table will never have more than 100 of records, but sent_messages
> > table it is a log table with a lot of records and the above query
> > will be executed every minute.
>
> Cross posting to multiple lists is frowned upon, so I'm reply only here.
>   Have you considered using the dblink contrib module?  That seems a far
> simpler solution than trying to do this with arrays.


Thank you for informations.

Best,
    Loredana

In response to

pgsql-novice by date

Next:From: Andrew MacleanDate: 2007-07-03 03:58:02
Subject: Re: [NOVICE] Recursive relationship - preventing cross-index entries.
Previous:From: Guy RouillierDate: 2007-07-02 15:38:16
Subject: Re: Replace usage of a table in query with its array values

pgsql-jdbc by date

Next:From: thomas.risbergDate: 2007-07-02 17:29:55
Subject: Re: getProcedureColumns
Previous:From: Guy RouillierDate: 2007-07-02 15:38:16
Subject: Re: Replace usage of a table in query with its array values

pgsql-sql by date

Next:From: Paul LambertDate: 2007-07-02 22:45:20
Subject: Using escape strings in an insert statement.
Previous:From: Guy RouillierDate: 2007-07-02 15:38:16
Subject: Re: Replace usage of a table in query with its array values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group