CHECK and IN (Sets in general) - What's the story? - Mailing list pgsql-sql

From k_ogorman@kompass.ie
Subject CHECK and IN (Sets in general) - What's the story?
Date
Msg-id 009CAFD5.71417C54.5@kompass.ie
Whole thread Raw
Responses Re: [SQL] CHECK and IN (Sets in general) - What's the story?
List pgsql-sql
Is there a known reason why the following definition fails
the parser at the IN keyword?:

create table kev_test ( my_tag  char check (my_tag in ('A', 'B', 'C')));

The keyword IN is defined in Postgres' dialect (or it seems to be), so I'm
at a loss as to the problem.

K.
-

--

Kevin O' Gorman - k_ogorman@kompass.ie - programmer, Kompass Internet

pgsql-sql by date:

Previous
From: Steve Maring
Date:
Subject: problem with LIKE predicate and wildcards
Next
From: Holger Mitterwald
Date:
Subject: Re: [SQL] CHECK and IN (Sets in general) - What's the story?