>>> On Fri, Jan 4, 2008 at 4:46 PM, in message <24033.1199486819@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> nor mentions the data types involved.Schema | Name | Type | Modifier | Check
--------+-------------------+-------------------------+----------+-------public | ArrestCaseNoT | character(12)
| |public | ArrestTrackingNoT | character(14) | |public | BookCaseNoT |
character(12) | |public | CalDurationT | numeric(6,2) | |public | CaseNoT
| character(14) | |public | CaseTypeT | character(2) | |public |
ChargeIdT | character varying(15) | |public | ChargeNoT | smallint |
|public| ChargeSeqNoT | smallint | |public | ChargeStatusCodeT | character varying(2) |
|public | CountyNoT | smallint | |public | CtofcNoT | character(4)
| |public | DateT | date | |public | DispoCodeT |
character(5) | |public | EventDescrT | character(50) | |public | EventTypeT
| character(5) | |public | HistSeqNoT | smallint | |public |
IssAgencyNoT | smallint | |public | JdgmtSeqNoT | smallint |
|public| KeyEventSeqT | smallint | |public | MoneyT | numeric(13,2) |
|public | OffenseDateRangeT | character varying(100) | |public | PdCodeT | character(2)
| |public | PleaCodeT | character(4) | |public | PlntfAgencyNoT |
smallint | |public | SccaCaseNoT | character varying(14) | |public |
SevClsCodeT | character(2) | |public | StatuteCiteT | character(21) |
|public| StatuteDescrT | character varying(100) | |public | StatuteSevSeqNoT | smallint |
|public | TagTypeT | character(2) | |public | TapeCounterNoT | character(16)
| |public | TapeLocT | character(18) | |public | TextT |
charactervarying(2000) | |public | UserIdT | character(8) | |public |
WcisClsCodeT | character(5) | |
We're in the process of converting all of the char to varchar, but
both the previous report and this one still have char as shown here.
-Kevin