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