Re: Wild Cards

On Thu, Jan 25, 2001 at 02:29:55PM -0500, Brett W. McCoy wrote:
> On Thu, 25 Jan 2001, <No Name> wrote:
> 
> > I am not able to get Wildcards in PostgreSQL, I know its * (asterisk), but
> > its not working. can someone show me a example or something?
> 
> Wildcards where?  You can use * to mean all the fields in a table in a
> SELECT statement, but if you are using LIKE in a WHERE clause, the
> wildcards are % to mean any group of characters and _ to mean any single
> character.

Although, of course, you can use POSIXlish regexps with the ~* and ~
operators.

-- 
Rodger Donaldson        rodgerd@diaspora.gen.nz
"My mother made me a lesbian"
"Oh goody! If I buy her the wool, will she make me one too??"