[rlug] Re: Postgres again

[Petru Paler]

On Thu, Oct 26, 2000 at 08:25:48AM +0300, Vasiliu Constantin wrote:
> 2. Ce este gresit in :
>    SELECT nume FROM relation WHERE nume~'[A-C]*'
> (asta ar trebui sa-mi dea doar numele care incep cu literele mari A,B,C
> dar imi da toata relatia)

SELECT nume FROM relation WHERE nume ~ '^[A-C].*$'

netestat, YMMV :)

--
Petru Paler, mailto:[EMAIL PROTECTED]
http://www.ppetru.net - ICQ: 41817235

---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to 
unsubscribe from this list.