Re: repost of how to do select in a constraint
От | Dennis Gearon |
---|---|
Тема | Re: repost of how to do select in a constraint |
Дата | |
Msg-id | VTWUOSRFD0797SQA63XUPUP84IHC0Q.3e2ec6e1@cal-lab обсуждение исходный текст |
Ответ на | Re: repost of how to do select in a constraint ("Peter Gibbs" <peter@emkel.co.za>) |
Список | pgsql-general |
Thank you VERY, VERY much. Since I am in the planning stages of the database, and don't have it sited yet, these few questions that I might be able to answer by playing around on a database hold me up. By answering them, you on this list, Peter in particular, have really moved my development forward. 1/21/2003 10:11:41 PM, "Peter Gibbs" <peter@emkel.co.za> wrote: >Dennis Gearon wrote: > >> Can I reference a function in a column check constraint, when the function >doesn't yet exist, >> i.e. a the time of table creation? >> >> Or is it better to make the table, create the function, then alter table >with a check >> constraint? > >The function has to exist before the constraint is created. If the function >depends on the table that will have the constraint, you will need to add the >constraint afterwards; however, if the function only depends on other >tables, then you can create the function before creating the table. >-- >Peter Gibbs >EmKel Systems > >
В списке pgsql-general по дате отправления: