standard sql operators

From: harrold(at)sage(dot)che(dot)pitt(dot)edu
To:
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: standard sql operators
Date: 2001-08-13 22:16:47
Message-ID: Pine.LNX.4.21.0108131808250.2982-100000@sage.che.pitt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hey.

i have a question about 'LIKE', 'ILIKE' and the regular expression match
operators '~, ~*, !~, !~*'. i realize the regular expression operators
are those set by the posix standard, but i dont believe they are part of
the sql standard. is 'LIKE'/'ILIKE' a standard sql operator?

i looked for a while but i could not find the actual sql standards.

if someone could point me to a website with the standards for sql that
would be great.

my concern here is portability of applications.

thanks
john

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Johann Zuschlag 2001-08-13 22:32:50 Overwriting Operator for numeric and float8 fails
Previous Message Noah Roberts 2001-08-13 19:40:54 Re: permission errors