Re: [SQL] SELECT from a list

2004-07-25 Thread Tom Lane
Markus Bertheau <[EMAIL PROTECTED]> writes: > В Вск, 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. [ raised eyebrow... ] I was under the impression that we ha

Re: [SQL] SELECT from a list

2004-07-25 Thread Markus Bertheau
Ð ÐÑÐ, 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 <[EMAIL PROTECTED]> ---(end of broadcast)---

Re: [SQL] SELECT from a list

2004-07-25 Thread Jean-Luc Lachance
Markus Bertheau wrote: Ð ÐÑÐ, 25.07.2004, Ð 15:18, Keith Gallant ÐÐÑÐÑ: Hello I am wondering if it is possible to use a SINGLE LIKE statement for a selection from a list. For example: If I want to return all results that a phrase starts with a number, can I make a call similar to the following: SE

Re: [SQL] SELECT from a list

2004-07-25 Thread Markus Bertheau
Ð ÐÑÐ, 25.07.2004, Ð 15:18, Keith Gallant ÐÐÑÐÑ: > Hello > > I am wondering if it is possible to use a SINGLE LIKE statement for a > selection from a list. > > For example: If I want to return all results that a phrase starts with a > number, can I make a call similar to the following: > > SELEC