Skip site navigation (1) Skip section navigation (2)

Re: mysql set datatype

From: Richard Huxton <dev(at)archonet(dot)com>
To: Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: mysql set datatype
Date: 2004-12-13 13:25:48
Message-ID: 41BD985C.4030102@archonet.com (view raw or flat)
Thread:
Lists: pgsql-sql
Kenneth Gonsalves wrote:
> hi,
> how does one replicate the myql 'set' datatype in pg? i tried using 'check', 
> but apparently there is much more to this

You could use a bit-string if you are just tracking set membership, but 
that doesn't exactly duplicate the behaviour. It should be 
straightforward enough to write some support functions and just use a 
text type, but that'd use a lot more storage.

Of course, another table is the accepted way of doing this relationally. 
  Are there any particular features you need, or are you just porting an 
application from Mysql?

--
   Richard Huxton
   Archonet Ltd

In response to

Responses

pgsql-sql by date

Next:From: Kenneth GonsalvesDate: 2004-12-13 13:43:25
Subject: Re: mysql set datatype
Previous:From: Richard HuxtonDate: 2004-12-13 13:18:58
Subject: Re: Hide schemas and tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group