Re: SELECT from a list

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Jean-Luc Lachance <jllachan(at)sympatico(dot)ca>
Cc: Keith Gallant <keith(at)justhosting(dot)ca>, pgsql-sql(at)postgresql(dot)org
Subject: Re: SELECT from a list
Date: 2004-07-25 16:21:56
Message-ID: 1090772515.9204.3.camel@teetnang
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

В Вск, 25.07.2004, в 16:40, Jean-Luc Lachance пишет:

> Better yet:
>
> SELECT * FROM table WHERE phrase ~ '^[0-9]';

Not so sure if that's better - the regex engines aren't the fastest.

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-07-25 17:34:21 Re: SELECT from a list
Previous Message Jean-Luc Lachance 2004-07-25 14:40:22 Re: SELECT from a list