Re: [SQL] I can be a BUG?

2000-12-02 Thread Edipo E. F. Melo
On Fri, 01 Dec 2000 18:00:42 -0500, Tom Lane wrote: >It kinda sounds like your wife created those tables in template1. > >Duplicating template1's contents into new databases isn't a bug, >it's a feature ;-) That's it! I didn't see she created on template1 and on project database too. Tha

Re: [SQL] subselects

2000-12-02 Thread hubert depesz lubaczewski
On Wed, Nov 29, 2000 at 07:03:36PM -0500, Joseph Shraibman wrote: > I tried to do this: > SELECT r , a , (SELECT u , re FROM dir WHERE u = a) , cdate FROM rep > WHERE m IN(190); why dont you use simple join? like: select rep.r, rep.a, rep.cdate, dir.u, dir.re from rep, dir where rep.m in (190) a