where = like ~+

From: BPascal <pascal62fr(at)free(dot)fr>
To: pgsql-fr-generale(at)postgresql(dot)org
Subject: where = like ~+
Date: 2009-02-12 16:58:23
Message-ID: 4994552F.8020600@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-fr-generale

Bonjour,

Je souhaite améliorer la clause where de ce select

$query_tele = "SELECT * FROM \"V_TelCli2Eta\" WHERE
\"V_TelCli2Eta\".\"Nom\" = '$filtre_page' ORDER BY \"IdTelechargement\"
DESC LIMIT $taille_page OFFSET $debut";

Je souhaite une comparaison moins strict, j'ai essayé les deux variantes
suivantes sans succès.

WHERE \"V_TelCli2Eta\".\"Nom\" LIKE '$filtre_page'

WHERE \"V_TelCli2Eta\".\"Nom\" ~+ '$filtre_page'

Comment avoir une comparaison moins strict.

A+
--
Pascal

Responses

Browse pgsql-fr-generale by date

  From Date Subject
Next Message Guillaume Lelarge 2009-02-12 17:03:15 Re: where = like ~+
Previous Message Stéphane A. Schildknecht 2009-02-11 11:18:43 [Pgday] Préparation du PGDay 2009