On 12/2/2013 3:46 PM, Nick wrote:
Hello I am new to this site and also a student. I am working on an assignment and was wondering if there is a way to make an alias for a boolean? For example when I am making a table called club_games and it must contain the memberID, gameID, count, and status as column fields. When I enter the data for status I want it to say either "unavailable" for false and "available" for true. but I don't know how to do that.
you could use an enum, or you could use a case statement on your query, like,
SELECT memberID, gameID, hardwareID, count, case when status then 'available' else 'unavailable' end FROM club_Games -- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
