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

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: How to script inserts where id is needed as fk
Дата
Msg-id 1384034116071-5777610.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: How to script inserts where id is needed as fk  (Michael Schmidt <css.liquid@gmail.com>)
Ответы Re: How to script inserts where id is needed as fk  (Michael Schmidt <css.liquid@gmail.com>)
Список 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.



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Jonathan S. Katz"
Дата:
Сообщение: Re: How to script inserts where id is needed as fk
Следующее
От: Michael Schmidt
Дата:
Сообщение: Re: How to script inserts where id is needed as fk