[SQL] single byte unsigned integer datatype

Hello, I was looking for a datatype to represent a single byte unsigned integer. The closest thing I can find looking through the online manual is a one byte char. Are there any side-effects of using a char datatype for this purpose? Is there a better datatype to use? Thanks in advance, Joe

[SQL] importing of ISO file to Postgresql

Dear Sir, I m doing a library managementprogram using Postgresql as backend. We are given an ISO 2709 format flat file which is onlya books dbasewhich is to be converted to postgres format My Q is that where should I import the file ? Please if possible specify the file or directory where

Re: [SQL] single byte unsigned integer datatype

Joe Conway writes: I was looking for a datatype to represent a single byte unsigned integer. The closest thing I can find looking through the online manual is a one byte char. Are there any side-effects of using a char datatype for this purpose? Yes, it won't store single byte unsigned

Re: [SQL] importing of ISO file to Postgresql

Sharmad Naik wrote: Dear Sir, I m doing a library management program using Postgresql as backend. We are given an ISO 2709 format flat file which is only a books dbase which is to be converted to postgres format My Q is that where should I import the file ? Please if possible

[SQL] SQL question

I'm trying to extract references (relationships) between tables for the purpose of reverse/forward engineer from a modeling tool called PowerDesigner. Here is the sql: select u.usename, p.relname, v.usename, c.relname, t.tgconstrname, dumpref(t.tgargs, 4),

Re: [SQL] Using INDEX on date/time values // Re: how to select a time frame on timestamp rows.

On Sun, Jan 14, 2001 at 04:46:08AM +0100, Alvar Freude wrote: Peter Eisentraut schrieb: today i was trying to perform a query on a database using a time stamp field, i need to get all records which belong to year 2000, month 11, [...] select user_name from tbacct where