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,
orare you just porting an
application from Mysql?
-- Richard Huxton Archonet Ltd