Re: [GENERAL] referential integrity constraints not checked inside

2004-05-13 Thread James M Moe
Christian Rank wrote: create table a (n integer); create table b (n integer); alter table a add primary key (n); alter table b add foreign key (n) references a(n); Have you considered using "on delete cascade" in table b? -- jimoe at sohnen-moe dot com -

Re: [GENERAL] Seaching without accents

2004-01-28 Thread James M Moe
Augusto Cesar Castoldi wrote: How can I configure postgreSQL to search without acents? Table “test” Clumns: name , values: Test Test tést Tést Since those are actually different characters that only look the same, you would have to use another approach: select * from test where name like '