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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-novice pgsql-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

Browse pgsql-jdbc by date

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

Browse pgsql-novice by date

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

Browse pgsql-sql by date

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