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. This is what I have currently for the line that I am specifically talking about: INSERT INTO club_Games(memberID, gameID, hardwareID, count, status) VALUES ((SELECT memberID FROM members WHERE name = 'Fred Flinstone'), (SELECT gameID FROM games WHERE name = 'Jurrasic Park'), NULL, 1, 'true'); when I do the SELECT * FROM club_Games this is my output: id gameid memberid hardwareid count status 1 12345zzzzz A12345 <null> 1 t Where it says t for status I wanted it to say available but mean true for boolean, but I don't know how to do that. Thanks to all for help. My file is attached if you would like to view my assignment. task5.txt <http://postgresql.1045698.n5.nabble.com/file/n5781328/task5.txt> -- View this message in context: http://postgresql.1045698.n5.nabble.com/Inserting-boolean-types-as-an-alias-tp5781328.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
