Re: one to many

So, you're looking for something like "referenced by" instead of the
SQL-standard "references"?

Seems like you could always whip up a stored procedure....


On May 16, 2004, at 9:27 AM, Dennis Gearon wrote:

> CC me please.
>
> How do I set up a one to many relationship in Postgres, (any DB for
> that matter.)
>
> I.E., if a delete or update of a child table causes a row in the
> parent table to no longer refer to any rows in the child table, to
> either cause Postgres to error out or delete the parent? I can see it
> does it for when a parent is upudated or deleted.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if
> your
>      joining column's datatypes do not match