| From: | Dennis Gearon <gearond(at)cvc(dot)net> |
|---|---|
| To: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
| Cc: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 0/1 vs true/false |
| Date: | 2003-07-23 13:57:23 |
| Message-ID: | 3F1E9443.4070106@cvc.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html;charset=ISO-2022-JP">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
I have looked around, but not found the standard. Where I have looked,
it seems to be:<br>
<br>
t/f,<br>
..... not........<br>
true/flase<br>
0/1<br>
yes/no<br>
<br>
Jean-Christian Imbeault wrote:
<blockquote type="cite">
<pre wrap="">Nigel J. Andrews wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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.
</pre>
</blockquote>
<pre wrap=""><!---->
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 <a class="moz-txt-link-abbreviated" href="mailto:majordomo(at)postgresql(dot)org">majordomo(at)postgresql(dot)org</a> so that your
message can get through to the mailing list cleanly
</pre>
</blockquote>
<br>
<br>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-07-23 14:19:00 | Re: How do I manage PDF file |
| Previous Message | Joepie Platteau | 2003-07-23 13:15:41 | Psql - locks records... |