Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql 'prefix' - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: pgsql 'prefix'
Date
Msg-id 330B79B9-69ED-48DE-8254-0BBB97FE13A6@hi-media.com
Whole thread Raw
In response to Re: How is the right query for this condition ?  (Harald Fuchs <hari.fuchs@gmail.com>)
List pgsql-general
Tree view 
Hi,

Le 23 nov. 2009 à 17:04, Harald Fuchs a écrit :
> SELECT id, record
> FROM myrecords
> WHERE record @> '127'
> ORDER BY length(record::text) DESC
> LIMIT 1;

In prefix 1.0.0 you can say ORDER BY length(record) DESC directly...
--
Dimitri Fontaine
PostgreSQL DBA, Architecte

pgsql-general by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: limiting resources to users
Next
From: Postgres User
Date:
Subject: Postgres database performance on 6 core Opteron vs 4 core Xeon