Re: [SOCI-users] enums in postgresql

2010-01-13 Thread Maciej Sobczak
Hello, Shridhar Daithankar wrote: > Given recent discussions and my needs for enum support, I experimented a bit > and found that postgresql enums works perfectly as text. Essentially they are > predefined values of text. Yes, now I see what you mean. Of course, with PostgreSQL you can transf

[SOCI-users] enums in postgresql

2010-01-13 Thread Shridhar Daithankar
Hello All, Given recent discussions and my needs for enum support, I experimented a bit and found that postgresql enums works perfectly as text. Essentially they are predefined values of text. PFA a test program to demonstrate that. Here is the sql session and the program run. The select was r