Re: How to script inserts where id is needed as fk

From: David Johnston <polobo(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to script inserts where id is needed as fk
Date: 2013-11-09 21:55:16
Message-ID: 1384034116071-5777610.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Michael Schmidt-2 wrote
> To extend my scenario a little bit i have a third level called
> 'Incredient' and they need the Article id. I dont think this will work
> anymore with the with clause. Any new approaches?

Why don't you just use a procedural language function? plpgsql should be
sufficient for most requirements.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-script-inserts-where-id-is-needed-as-fk-tp5777525p5777610.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Schmidt 2013-11-09 23:20:59 Re: How to script inserts where id is needed as fk
Previous Message Jonathan S. Katz 2013-11-09 21:15:38 Re: How to script inserts where id is needed as fk