pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Markus Bertheau <twanger@bluetwanger.de>
To: Jean-Luc Lachance <jllachan@sympatico.ca>
Cc: Keith Gallant <keith@justhosting.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: SELECT from a list
Date: Sun, 25 Jul 2004 18:21:56 +0200
Message-ID: <1090772515.9204.3.camel@teetnang> (raw)
In-Reply-To: <4103C656.4070109@sympatico.ca>
References: <PDENIKIKNMLHOJKGJDLGCEPCCGAA.keith@justhosting.ca>
	<1090763779.9204.1.camel@teetnang>
	<4103C656.4070109@sympatico.ca>

В Вск, 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>




view thread (5+ messages)  latest in thread

Message-ID: <1090772515.9204.3.camel@teetnang>
Permalink:  ../1090772515.9204.3.camel@teetnang/
Also on:    postgresql.org/message-id/1090772515.9204.3.camel@teetnang

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: twanger@bluetwanger.de, jllachan@sympatico.ca, keith@justhosting.ca
  Subject: Re: SELECT from a list
  In-Reply-To: <1090772515.9204.3.camel@teetnang>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox