Re: How to use the SET data type?  Help plz!

Odd that it is a selectable datatype in pgadmin then huh?
If there are no sets, then is there anythign else that can be used to
represent that type of data.  I used them a lot in a mySQL database that I am
migrating from.  It is very useful to have a predefined set of values to
choose from, otherwise it would just be a text field with no constraints as to
the contents.  It is also nice to have the popup menus of the selecable values
when inputing data like how phpmyadmin handles sets. It seem slike a huge
oversight to not support them.


> Ummmm...PostgreSQL doesn't support sets...
>
> Chris
>
> pgadmin@claymccoy.com wrote:
>
> > When I add a column a table I am able to choose the SET DataType, but
there is
> > no obvious way to define the acceptable values for the set.
> > I'd like to use the gui that I use for creating all my other columns
rather
> > than doing it by hand.  The generated sql from the gui doesn't even seem
right
> > because it puts set in quotes.  I can't even enter sql by hand that should
add
> > a set with values, of course my syntax might not be right as I can't seem
to
> > find a good example for creating a set.
> > Can anyone help me in using sets with pgadmin?
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
> Ummmm...PostgreSQL doesn't support sets...

Chris

pgadmin@claymccoy.com wrote:

> When I add a column a table I am able to choose the SET DataType, but there is
> no obvious way to define the acceptable values for the set.
> I'd like to use the gui that I use for creating all my other columns rather
> than doing it by hand.  The generated sql from the gui doesn't even seem right
> because it puts set in quotes.  I can't even enter sql by hand that should add
> a set with values, of course my syntax might not be right as I can't seem to
> find a good example for creating a set.
> Can anyone help me in using sets with pgadmin?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly