On Mon, 10 Mar 2003 10:12:15 +0100
Tomasz Myrta <[EMAIL PROTECTED]> wrote:
> Andre Schubert wrote:
> > Hi all,
> >
> > i have a little problem on indexing a table which contains
> > about 4 millions of traffic-data.
> > My problem is, that a want to select
On Fri, 7 Mar 2003 15:03:01 -0200 (GMT+2)
Achilleus Mantzios <[EMAIL PROTECTED]> wrote:
> On Fri, 7 Mar 2003, Andre Schubert wrote:
>
> > On Fri, 7 Mar 2003 14:17:36 -0200 (GMT+2)
> > Achilleus Mantzios <[EMAIL PROTECTED]> wrote:
> >
> >
On Thu, 15 Aug 2002 11:17:15 +0900
"Masaru Sugawara" <[EMAIL PROTECTED]> wrote:
> On Wed, 14 Aug 2002 16:04:21 +0200
> Andre Schubert <[EMAIL PROTECTED]> wrote:
>
>
> > I want to compare if a tuple in c exist in b for each c.d_id and b.a_id.
> > I
On Wed, 14 Aug 2002 21:57:02 +0900
"Masaru Sugawara" <[EMAIL PROTECTED]> wrote:
> On Wed, 14 Aug 2002 09:10:53 +0200
> Andre Schubert <[EMAIL PROTECTED]> wrote:
>
> > The ride side as follows.
> > Table d contains information about subitems.
>
me4.
Hope these informations describe my problema little bit better.
I have played with some plpgsql-functions but found no way.
The problem is the 0..n relation between a+b and c+d.
Regards
andre
>
> --- Andre Schubert <[EMAIL PROTECTED]> wrote:
> > Hi all,
> >
&g
Hi all,
i need help to build a select query or plpgsql-fucntion
for the following tables.
create table a (
id int,
name varchar(20)
)
create table b (
a_id int,
c_id int
)
create table c (
b_id int,
d_id int
)
create table d (
id int,
name varchar(20)
)
Is it possible to build a select query
