Re: [SQL] I can be a BUG?

[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. Thank's for help!


[]'s

Edipo Elder F. de Melo

Re: [SQL] subselects

[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) and rep.a = dir.u;

this should (i guess) work perfectly

depesz

-- 
hubert depesz lubaczewski

 najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
  jest niesamowita wręcz łatwość unikania kontaktów z nim ...