"Vladimir V. Zolotych" wrote:
>Hi
>
>Please help me compose the query in PostgreSQL.
>Using PostgreSQL 7.1.2.
>
>Suppose relations A and B have columns:
> {X1, X2, ..., Xm, Y1, Y2, ..., Yn}
>and
> {Y1, Y2, ..., Yn}
>Attributes Y1, Y2, ..., Yn are common for both relations
>
Hi
Please help me compose the query in PostgreSQL.
Using PostgreSQL 7.1.2.
Suppose relations A and B have columns:
{X1, X2, ..., Xm, Y1, Y2, ..., Yn}
and
{Y1, Y2, ..., Yn}
Attributes Y1, Y2, ..., Yn are common for both relations
and have the same type in both.
How can I define in PostgreSQL