Re: [SQL] CHECK and IN (Sets in general) - What's the story? - Mailing list pgsql-sql

From Holger Mitterwald
Subject Re: [SQL] CHECK and IN (Sets in general) - What's the story?
Date
Msg-id Pine.GSO.4.02.9808210916380.7604-100000@su00574
Whole thread Raw
In response to CHECK and IN (Sets in general) - What's the story?  (k_ogorman@kompass.ie)
List pgsql-sql
On Thu, 20 Aug 1998 k_ogorman@kompass.ie wrote:

> 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')));

It isn't this worse at all :-)

First, your syntax is not correct.
Second, you can change the 'IN' Clause with several 'OR' clauses.
The result would look like this:

create table kev_test ( my_tag  char) constraint tester check (my_tag =
'A' OR my_tag='B' OR my_tag = 'C');

If somebody has a solution for the 'IN' construction.... mail it!

So long,
        Holger
--------------------------------------------------------------------------------
Holger Mitterwald COI-D        ####   #####    ###       CONSULTING FUER OFFICE
COI GmbH Herzogenaurach       #      #     #    #        UND INFORMATION
Industriestrasse 1 - 3        #      #     #    #        MANAGEMENT GmbH
D-91074 Herzogenaurach         ####   #####    ###       Tel.: 09132/82-3811


pgsql-sql by date:

Previous
From: k_ogorman@kompass.ie
Date:
Subject: CHECK and IN (Sets in general) - What's the story?
Next
From: Chauncey_Thorn@RohmHaas.Com (Chauncey Thorn)
Date:
Subject: SQL statement Problem