Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA29754; Thu, 8 Oct 92 13:14:44 -0700
Message-Id: <9210082014.AA29754@postgres.Berkeley.EDU>
From: <mao@postgres.berkeley.edu>
Subject: Re: no subject (file transmission)
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Thu, 08 Oct 92 14:58:56 MDT.
             <9210081956.AA29525@postgres.Berkeley.EDU> 
Date: Thu, 08 Oct 92 13:17:23 PDT

In message <9210081956.AA29525@postgres.Berkeley.EDU> you write:

> Does anyone know of any wildcards that can be used in a retrieve request?

try

	retrieve (nameclass.name) where nameclass.name ~ "Bill.*"\g

the syntax of the string between quotes is what is documented in the
unix manual under regexp(3).

postgres supports ~ (pattern match) and !~ (pattern mismatch) for text
and char16 datatypes.
					mike