Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-fr-generale by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group