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

Re: [INTERFACES] Re: LIKE clause

From: "E(dot)E(dot) Mellor" <eem21(at)cam(dot)ac(dot)uk>
To: Thomas Byrnes <tbyrnes(at)helioshealth(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [INTERFACES] Re: LIKE clause
Date: 1999-10-25 16:57:53
Message-ID: Pine.SOL.4.10a.9910251755520.20073-100000@orange.csi.cam.ac.uk (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
On Mon, 25 Oct 1999, Thomas Byrnes wrote:

> Alright, it seems simple enough, but I am having no luck figuring out the
> syntax for the LIKE clause.
> 
> I have tried: WHERE name LIKE 'A*' and other similar combinations to no
> avail. Anyone have any suggestions?

LIKE 'A%', if I remember correctly.

Ewan.


In response to

pgsql-interfaces by date

Next:From: Jacob ChristenDate: 1999-10-25 18:13:46
Subject: Re: [INTERFACES] Re: LIKE clause
Previous:From: Thomas ByrnesDate: 1999-10-25 16:05:26
Subject: RE: [INTERFACES] Re: LIKE clause

pgsql-general by date

Next:From: Aaron J. SeigoDate: 1999-10-25 17:23:19
Subject: Re: [GENERAL] retrieving last 3 rows
Previous:From: Stephen WaltonDate: 1999-10-25 16:32:54
Subject: Slow lookups on dates? Or something else?

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