关键字varchar(32),文本文件 为数据表添加一个触发器,以便它连接到(父)关键字表并增加keyword.sequence值,并将其放入Data.sequence值。 当您从数据表。如果这是一个问题,那么你将需要另一种设计。 希望有所帮助。 John Sidney-Woollett Anthony Best说: ---------------------------(广播结束)---------- ----------------- 提示8:解释分析是你的朋友 --------- ------------------(广播结束)--------------------------- 提示1:订阅和取消订阅命令转到 ma*******@postgresql.org I''m working on an idea that uses sequences. I''m going to create a table like this: id serial,sequence int,keyword varchar(32),text text for every keyword there will be a uniq sequence for it eg: id, sequence, keyword1, 1, foo, ver12, 1, bar, bar ver13, 2, foo, ver24, 2, bar, bar ver2etc... I could have one sequence for all keyword which would be 1,3, etc... Iwould be prefer to have them in sequence. I''m sure someone has ran intothis before, any ideas? Anthony.---------------------------(end of broadcast)---------------------------TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org 解决方案 ---------------------------(end of broadcast)---------------------------TIP 8: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend---------------------------(end of broadcast)---------------------------TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org 这篇关于序列问题。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 10-27 22:29