Re: SELECT from a list - Mailing list pgsql-sql

From Markus Bertheau
Subject Re: SELECT from a list
Date
Msg-id 1090772515.9204.3.camel@teetnang
Whole thread Raw
In response to Re: SELECT from a list  (Jean-Luc Lachance <jllachan@sympatico.ca>)
Responses Re: SELECT from a list  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@bluetwanger.de>



pgsql-sql by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: SELECT from a list
Next
From: Tom Lane
Date:
Subject: Re: SELECT from a list