Re: [GENERAL] Enumerated data type

2000-05-02 Thread Robert B. Easter
On Tue, 02 May 2000, Tom Cook wrote: > On Tue, 2 May 2000, Peter Eisentraut wrote: > > > Anand Raman writes: > > > > > Is there anything equivalent to the enumerated data types in > > > postgresql.. > > > > You might find that strings with check constraints will do the job, e.g. > > > > create

Re: [GENERAL] Enumerated data type

2000-05-02 Thread Tom Cook
On Tue, 2 May 2000, Peter Eisentraut wrote: > Anand Raman writes: > > > Is there anything equivalent to the enumerated data types in > > postgresql.. > > You might find that strings with check constraints will do the job, e.g. > > create table my_tbl ( > ... > color text check color in ('blu

Re: [GENERAL] Enumerated data type

2000-05-02 Thread Peter Eisentraut
Anand Raman writes: > Is there anything equivalent to the enumerated data types in > postgresql.. You might find that strings with check constraints will do the job, e.g. create table my_tbl ( ... color text check color in ('blue', 'green', 'white'), ... ); -- Peter Eisentraut

[GENERAL] Enumerated data type

2000-05-01 Thread Anand Raman
HI guys Is there anything equivalent to the enumerated data types in postgresql.. Thanx for ur help Anand Raman