Re: Is This A Set Based Solution?

From: Stefan Berglund <sorry(dot)no(dot)koolaid(at)for(dot)me>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Is This A Set Based Solution?
Date: 2007-03-10 06:32:58
Message-ID: vsj4v2dcmg6dcmnq2ne34g1jq68r31kf6r@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 10 Mar 2007 08:26:32 +0300 (MSK), oleg(at)sai(dot)msu(dot)su (Oleg
Bartunov) wrote:
in <Pine(dot)LNX(dot)4(dot)64(dot)0703100824300(dot)400(at)sn(dot)sai(dot)msu(dot)ru>

>I don't know if you could change your schema. but I'd consider your
>problem as a overlapping arrays task and use contrib/intarray for that.
>
>Oleg

I can very definitely change my schema at this point. I'm refactoring
an application from SQL Server to PostgreSQL and I'm doing a lot of
exploring trying to find the best fits. I'll see what I can glean from
you've indicated but that sounds like what I'm looking for. The string
converts easily to an array but then what's the best way to get from an
array to a table?

---
This posting is provided "AS IS" with no warranties and no guarantees either express or implied.

Stefan Berglund

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Michel Pouré 2007-03-10 09:26:21 Re: Tsearch2 / Create rule on select
Previous Message Stefan Berglund 2007-03-10 06:24:04 Re: Is This A Set Based Solution?