Re: Inserting boolean types as an alias?

On Mon,  2 Dec 2013 15:46:17 -0800, Nick wrote:
[...]
> 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.

Alternate suggestion: If you want to use a boolean column here,
maybe you could consider naming the column "available", not "status".

id     gameid        memberid      hardwareid    count     available
1      12345zzzzz    A12345        <null>        1         t

--
Michał Politowski
Talking has been known to lead to communication if practiced carelessly.