Received: from hub.org.org (localhost [127.0.0.1]) by hub.org (8.10.1/8.11.0) with SMTP id e9NNDBN68955 for ; Mon, 23 Oct 2000 19:13:11 -0400 (EDT) (envelope-from pgsql-sql-owner@hub.org) Received: from maynard.mail.mindspring.net (maynard.mail.mindspring.net [207.69.200.243]) by hub.org (8.10.1/8.11.0) with ESMTP id e9LEIwJ71059 for ; Sat, 21 Oct 2000 10:18:58 -0400 (EDT) (envelope-from radevenz@ix.netcom.com) Received: from supermicro (pool-63.53.112.65.nwrk.grid.net [63.53.112.65]) by maynard.mail.mindspring.net (8.9.3/8.8.5) with SMTP id KAA13877 for ; Sat, 21 Oct 2000 10:18:57 -0400 (EDT) Message-ID: <023401c03b69$bcc55df0$0101a8c0@supermicro> From: "Richard DeVenezia" To: Subject: Help: Using a regular expression match as a value Date: Sat, 21 Oct 2000 10:18:07 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Archive-Number: 200010/199 X-Sequence-Number: 1861 I am just getting started with pgsql and have read available docs I can find. I know I can match a row in a where clause using a regular expression. How can I use what was regexp matched (e.g. perl $1,$2, etc...) as a column assignment ? I'm looking for something like this? select ... ... $1 of firstname, /^R.*d/ as name_starts_with_r_and_ends_with_d ... TIA Richard DeVenezia