Postgres Pro
Downloads
Home   >   mailing lists

Re: Select question..... is there a way to do this? - Mailing list pgsql-general

From Rodrigo De León
Subject Re: Select question..... is there a way to do this?
Date
Msg-id 1186207688.409763.261840@k79g2000hse.googlegroups.com
Whole thread Raw
In response to Select question..... is there a way to do this?  (Karl Denninger <karl@denninger.net>)
List pgsql-general
Tree view 
On Aug 3, 11:17 pm, k...@denninger.net (Karl Denninger) wrote:
> Ideas?

SELECT item.user, item.subject, item.number
  FROM item, seen
 WHERE item.user = seen.user
   AND item.number = seen.number
   AND item.changed > seen.lastviewed
UNION
SELECT item.user, item.subject, item.number
  FROM item, seen
 WHERE item.user = seen.user
   AND seen.number IS NULL
   AND item.changed > seen.lastviewed;

pgsql-general by date:

Previous
From: Karl Denninger
Date:
Subject: Select question..... is there a way to do this?
Next
From: cluster
Date:
Subject: Safe usage of tsearch2: to_tsquery('')