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??"