Postgres Pro
Downloads
Home   >   mailing lists

Re: How to script inserts where id is needed as fk - Mailing list pgsql-sql

From David Johnston
Subject Re: How to script inserts where id is needed as fk
Date
Msg-id 1384034116071-5777610.post@n5.nabble.com
Whole thread Raw
In response to Re: How to script inserts where id is needed as fk  (Michael Schmidt <css.liquid@gmail.com>)
Responses Re: How to script inserts where id is needed as fk  (Michael Schmidt <css.liquid@gmail.com>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: Re: How to script inserts where id is needed as fk
Next
From: Michael Schmidt
Date:
Subject: Re: How to script inserts where id is needed as fk