Re: 0/1 vs true/false

<meta http-equiv="Content-Type"
 content="text/html;charset=ISO-2022-JP">



I have looked around, but not found the standard. Where I have looked,
it seems to be:

    t/f,
     ..... not........
    true/flase
    0/1
    yes/no

Jean-Christian Imbeault wrote:

  Nigel J. Andrews wrote:


    I had do do this sort of thing for a some developers. It was actually 'true'
and 'false' that was wanted not the 0/1. I wrote a little plgsql function and
installed it as a cast to text.



Thanks. I know that there are workarounds, I just want to "prove" that
0/1 is not standards compliant. If I can do that I am pretty sure that
the developer will have nothing against changing to true/false.

Right not he just things postgresql must be broken because 0/1 works in
MySQL ... But he's pretty good when it comes to fixing things because
they don't follow standards. So if I can show him his SQL isn't
standards compliant he'll probably happily fix it.

Jean-Christian Imbeault


---------------------------(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