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

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.