CHECK vs REFERENCES
От
Marc G. Fournier
Тема
CHECK vs REFERENCES
Дата
Msg-id
20050910001821.E1170@ganymede.hub.org
Список
Дерево обсуждения
CHECK vs REFERENCES "Marc G. Fournier" <scrappy@postgresql.org>
Re: CHECK vs REFERENCES Michael Fuhr <mike@fuhr.org>
Re: CHECK vs REFERENCES "Marc G. Fournier" <scrappy@postgresql.org>
Re: CHECK vs REFERENCES Michael Fuhr <mike@fuhr.org>
Re: CHECK vs REFERENCES Vivek Khera <vivek@khera.org>
Which is faster, where the list involved is fixed? My thought is that since it doesn't have to check a seperate table, the CHECK itself should be the faster of the two, but I can't find anything that seems to validate that theory ... The case is where I just want to check that a value being inserted is one of a few possible values, with that list of values rarely (if ever) changing, so havng a 'flexible list' REFERENCED seems relatively overkill ... Thoughts, or pointers to a doc that disproves, or proves, what I believe? Thanks ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
В списке pgsql-performance по дате отправления