> Does the SQL92 standard have to be purchased from the ANSI Board?
> Well, my actual question has to do with LIKE. Could anyone who has a
> copy of a standard send me the PATTERN syntax/meanings for LIKE in
Well, you may be hoping for more than is in any of your reference books,
but there isn't any more to tell :)
% ==> match any (sub)string
_ ==> match any single character
everything else matches itself
In SQL92 (but not yet in Postgres; can't remember if there is a
LIKE 'pattern' ESCAPE 'char'
allows a single character "char" if it precedes the two pattern matching
characters to demote the "%" or "_" to act like a normal single
character. The Postgres regex stuff is much more powerful.
Sorry, I think that's it :(
In response to
- SQL92 at 1998-09-29 14:53:45 from Jackson, DeJuan
pgsql-hackers by date
|Next:||From: Jackson, DeJuan||Date: 1998-09-29 17:03:06|
|Subject: RE: [HACKERS] SQL92|
|Previous:||From: David Hartwig||Date: 1998-09-29 16:27:34|
|Subject: Re: [HACKERS] PL/pgSQL in template1?|