Postgres Pro
Downloads
Home   >   mailing lists

Thread: Wild Cards

Wild Cards

From
""
Date:
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?

Re: Wild Cards

From
"Brett W. McCoy"
Date:
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.

-- Brett                                    http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
It's a good thing we don't get all the government we pay for.

Re: Wild Cards

From
Rodger Donaldson
Date:
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??"