if else query help - Mailing list pgsql-sql

From Brian C. Doyle
Subject if else query help
Date
Msg-id 5.0.0.25.2.20001012094914.081abeb0@pop.mindspring.com
Whole thread Raw
Responses Re: if else query help
List pgsql-sql
Hello all,

I need to write a query that will pull information from table2 if 
information in table1 is older then xdate.

My laymen example:

SELECT table2.date, count(table2.name) as count
WHERE table1.startdate > 2 weeks
AND table2.submitdate > 2 weeks
;

So i Guess my real questions is how do I determine the age of an entry to 
another table?





pgsql-sql by date:

Previous
From:
Date:
Subject: set digest
Next
From: Mark Volpe
Date:
Subject: Re: dynamic object creation