Changeset 11942 in project


Ignore:
Timestamp:
09/11/08 16:09:58 (13 years ago)
Author:
Mario Domenech Goulart
Message:

Changes applied for mario (200.132.45.200) through svnwiki:

Table fixes.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • wiki/postgresql

    r10460 r11942  
    166166<th>Scheme type</th>
    167167</tr>
    168 <tr> <td>TEXT</td> <td>string</td> </tr>
    169 <tr> <td>BYTEA</td> <td>string</td> </tr>
    170 <tr> <td>CHAR</td> <td>char</td> </tr>
    171 <tr> <td>BPCHAR</td> <td>char</td> </tr>
    172 <tr> <td>BOOL</td> <td>boolean</td> </tr>
    173 <tr> <td>INT8</td> <td>fixnum or inexact<sup>1</sup></td> </tr>
    174 <tr> <td>INT4</td> <td>fixnum or inexact<sup>1</sup></td> </tr>
    175 <tr> <td>INT2</td> <td>fixnum</td> </tr>
    176 <tr> <td>FLOAT8</td> <td>inexact</td> </tr>
    177 <tr> <td>FLOAT4</td> <td>inexact</td> </tr>
    178 <tr> <td>ABSTIME</td> <td>unsupported<sup>2</sup></td> </tr>
    179 <tr> <td>RELTIME</td> <td>unsupported<sup>2</sup></td> </tr>
    180 <tr> <td>DATE</td> <td>vector {{#(year month date)}}</td> </tr>
    181 <tr> <td>TIME</td> <td>vector {{#(hour minute second microsecond)}}</td> </tr>
    182 <tr> 
     168<tr><td>TEXT</td><td>string</td></tr>
     169<tr><td>BYTEA</td><td>string</td></tr>
     170<tr><td>CHAR</td><td>char</td></tr>
     171<tr><td>BPCHAR</td><td>char</td></tr>
     172<tr><td>BOOL</td><td>boolean</td></tr>
     173<tr><td>INT8</td><td>fixnum or inexact<nowiki><sup>1</sup></nowiki></td></tr>
     174<tr><td>INT4</td><td>fixnum or inexact<nowiki><sup>1</sup></nowiki></td></tr>
     175<tr><td>INT2</td><td>fixnum</td></tr>
     176<tr><td>FLOAT8</td><td>inexact</td></tr>
     177<tr><td>FLOAT4</td><td>inexact</td></tr>
     178<tr><td>ABSTIME</td><td>unsupported<nowiki><sup>2</sup></nowiki></td></tr>
     179<tr><td>RELTIME</td><td>unsupported<nowiki><sup>2</sup></nowiki></td></tr>
     180<tr><td>DATE</td><td>vector {{#(year month date)}}</td></tr>
     181<tr><td>TIME</td><td>vector {{#(hour minute second microsecond)}}</td></tr>
     182<tr>
    183183<td>TIMESTAMP</td>
    184184<td>vector {{#(year month date hour minute second microsecond)}}</td>
     
    188188<td>vector {{#(year month date hour minute second microsecond timezone)}}</td>
    189189</tr>
    190 <tr> <td>INTERVAL</td> <td>unsupported<nowiki><sup>2</sup></nowiki></td> </tr>
    191 <tr> <td>NUMERIC</td> <td>fixnum or inexact<nowiki><sup>1</sup></nowiki></td> </tr>
    192 <tr> <td>OID</td> <td>fixnum or inexact<nowiki><sup>1</sup></nowiki></td> </tr>
     190<tr><td>INTERVAL</td><td>unsupported<nowiki><sup>2</sup></nowiki></td></tr>
     191<tr><td>NUMERIC</td><td>fixnum or inexact<nowiki><sup>1</sup></nowiki></td></tr>
     192<tr><td>OID</td><td>fixnum or inexact<nowiki><sup>1</sup></nowiki></td></tr>
    193193</table>
    194194
    195195
    1961961. This means you will get a fixnum if the number is small enough, and a floating point number otherwise.  If it's too large to be represented as a floating point number, an error is signaled.
     197
    1971982. These are just returned as text for now.
    198199
Note: See TracChangeset for help on using the changeset viewer.