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.
> > In c exists 3 tuples: (1,2), (3,4), (5)
> > and w
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.
> In c exists 3 tuples: (1,2), (3,4), (5)
> and want to find these tuples in b.
Probably I would think I have reached the correct query. Table
On Wed, 14 Aug 2002 16:04:21 +0200
Andre Schubert <[EMAIL PROTECTED]> wrote:
> >
> >
> > If this mention implies that the tuple of (1, 1) in the c is supposed
^^
b
> > to t
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.
> > Table c holds information about subitems and items
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.
> Table c holds information about subitems and items of type bar.
> Each subitem can have 0..n items bar selected.
>
> What i want is that a sub
On Mon, 12 Aug 2002 08:11:48 -0700 (PDT)
"Ludwig Lim" <[EMAIL PROTECTED]> wrote:
Hi,
thank you for your quick response, but the answer you gave me
doesnt give the result i want.
Let me try to explain what i want.
Lets say that table a contains informations about
some items of the type foo.
Table
--- Andre Schubert <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> i need help to build a select query or
> plpgsql-fucntion
> for the following tables.
>> Is it possible to build a select query that selects
> d.name for each a.name where
> a.id = b.a_id and d.id = c.d_id and each b.c_id must
> exist i
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
