Re: [SQL] Help converting Oracle instead of triggers to PostgreSQL

2003-12-13 Thread Robert Treat
Just to follow up I managed to track down these missing articles and have updated the links on the website. Robert Treat On Thursday 04 December 2003 12:52, Clint Stotesbery wrote: Hi Christoph, Thanks for the links but the techdoc links for converting from Oracle to PostgreSQL has 2 links

Re: [SQL] Interest IN problem on 7.4

2003-12-13 Thread Stephan Szabo
On Sat, 13 Dec 2003, pginfo wrote: Hi, I am using pg 7.4. Pls, see this test: tt07=# update a_cars set dog_or_free=0 where virtualen=0 and dog_or_free=4 and ids NOT IN ( select oc.ids_car_real from a_oferti_cars oc,a_oferti o where oc.IDS_oferti=o.ids and o.date_valid=9964) AND IDS =

[SQL] INHERITS and Foreign keys

2003-12-13 Thread [EMAIL PROTECTED]
Hi I have some problem with INHERITS and foreign keys. I do not know if I have not got the clue or not. Anyway I have tried to simplify the problem so that you can guide me on the right track. I have two slightly different object A and B where 95% is common both of data and operations. Among