Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] SQL92

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
Cc: PostgreSQL Hackers Mailing List <pgsql-hackers(at)hub(dot)org>
Subject: Re: [HACKERS] SQL92
Date: 1998-09-29 16:46:06
Message-ID: 36110ECE.E3596440@alumni.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-hackers
> Does the SQL92 standard have to be purchased from the ANSI Board?

afaik, yes.

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

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
workaround):

  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 :(

                    - Tom

In response to

  • SQL92 at 1998-09-29 14:53:45 from Jackson, DeJuan

pgsql-hackers by date

Next:From: Jackson, DeJuanDate: 1998-09-29 17:03:06
Subject: RE: [HACKERS] SQL92
Previous:From: David HartwigDate: 1998-09-29 16:27:34
Subject: Re: [HACKERS] PL/pgSQL in template1?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group