From: | Rodger Donaldson <rodgerd(at)diaspora(dot)gen(dot)nz> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Wild Cards |
Date: | 2001-01-27 05:39:56 |
Message-ID: | 20010127183956.A5349@diaspora.gen.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)diaspora(dot)gen(dot)nz
"My mother made me a lesbian"
"Oh goody! If I buy her the wool, will she make me one too??"
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-27 07:14:36 | Re: |
Previous Message | Kovacs Baldvin | 2001-01-27 02:07:41 | Architectural question |