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

Re: mysql set datatype

From: Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: mysql set datatype
Date: 2004-12-13 13:43:25
Message-ID: 04121319132500.06834@thenilgiris.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Monday 13 December 2004 06:55 pm, Richard Huxton wrote:
> 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?

just porting

kg

In response to

pgsql-sql by date

Next:From: Christopher BrowneDate: 2004-12-13 16:35:07
Subject: Re: postgressql.org
Previous:From: Richard HuxtonDate: 2004-12-13 13:25:48
Subject: Re: mysql set datatype

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