Re: pgsql 'prefix'

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Harald Fuchs <hari(dot)fuchs(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pgsql 'prefix'
Date: 2009-11-25 19:50:38
Message-ID: 330B79B9-69ED-48DE-8254-0BBB97FE13A6@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Postgres User 2009-11-25 19:55:12 Postgres database performance on 6 core Opteron vs 4 core Xeon
Previous Message Devrim GÜNDÜZ 2009-11-25 19:25:33 PostgreSQL RPM packages for Fedora-12 released