Re: [SQL] Using SKYLINE command on PostgreSQL

2010-08-08 Thread Yeb Havinga
On Sun, Aug 8, 2010 at 5:35 AM, Craig Ringer wrote: > > The masters thesis page does contain a patch against PostgreSQL 8.3: > http://skyline.dbai.tuwien.ac.at/ > That page has a nice web page and examples where queries can be run. 'The skyline operator' is described in http://www.dbis.ethz.ch/r

Re: [SQL] tsearch2 query question

2010-08-08 Thread Tom Lane
=?ISO-8859-1?Q?Anders_=D8stergaard_Jensen?= writes: > Now, let's start out with a classic, non-tsearch2 ILIKE query with two > wildcards around the search token: > metabase=# select id, name from customers where name ilike '%holstebr%'; > id | name > --+--- > 3646 | H