Lists: | pgsql-sql |
---|
From: | "<No Name>" <bobmarley4u2c(at)yahoo(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Wild Cards |
Date: | 2001-01-25 13:39:52 |
Message-ID: | 94pa60$31fk$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
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?
From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
---|---|
To: | "<No Name>" <bobmarley4u2c(at)yahoo(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Wild Cards |
Date: | 2001-01-25 19:29:55 |
Message-ID: | Pine.LNX.4.30.0101251424510.24881-100000@chapelperilous.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
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.
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 |
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??"