Hello 2008/8/28 Bill <pg@xxxxxxxxxx>: > The SQL database servers I have worked with cannot use and index for a > SELECT of the form > > SELECT * FROM ATABLE > WHERE AFIELD LIKE ? > > because there is no way to know the location of the wild card until the > parameter value is known. InterBase and Firebird allow > > SELECT * FROM ATABLE > WHERE AFIELD STARTING WITH ? > > which is equivalent to LIKE 'ABC%' and will use an index on AFIELD. Is > there a similar syntax in PostgreSQL? > there is some similar - look http://www.depesz.com/index.php/2008/03/04/searching-for-longest-prefix/ http://pgfoundry.org/projects/prefix regards Pavel Stehule > Bill > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
