Re: standard sql operators

From: Gaetan GUYODO <gaetan(dot)guyodo(at)lrb(dot)ap-hop-paris(dot)fr>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: standard sql operators
Date: 2001-08-14 07:14:34
Message-ID: 01081409143401.04836@uc-102-233
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Take a look at pgsql documentation...user guide, page 10-15 I think.
there's a list of SQL reserved words (if that's what you search)
-> LIKE is a SQL92 or SQL3 reserved word

Gaetan

Le Mardi 14 Août 2001 00:16, vous avez écrit :
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Johann Zuschlag 2001-08-14 09:12:44 Re: Overwriting Operator for numeric and float8 fails
Previous Message Andrew McMillan 2001-08-14 04:24:43 Re: Overwriting Operator for numeric and float8 fails