Postgres Pro
Downloads
Home   >   mailing lists

standard sql operators - Mailing list pgsql-novice

From harrold@sage.che.pitt.edu
Subject standard sql operators
Date
Msg-id Pine.LNX.4.21.0108131808250.2982-100000@sage.che.pitt.edu
Whole thread Raw
In response to Overwriting Operator for numeric and float8 fails  ("Johann Zuschlag" <zuschlag@online.de>)
Responses Re: standard sql operators  (Gaetan GUYODO <gaetan.guyodo@lrb.ap-hop-paris.fr>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "Johann Zuschlag"
Date:
Subject: Overwriting Operator for numeric and float8 fails
Next
From: Andrew McMillan
Date:
Subject: Re: Overwriting Operator for numeric and float8 fails