[GENERAL] pg_dump of int8 with "?

2000-02-14 Thread kaiq
I'm using pg_dump as a data transfer tool to input data to m$sql. why I can not use copy and then m$sql's bcp? because m$sql strangly ignore the difference between null and empty string (in bcp's input format, no quotation mark used, just like pg. however, it has no escape for null.). so, I u

Re: [GENERAL] typecast for index

2000-02-14 Thread John Henderson
Thank you Ed, >IIRC, this is a known issue with 'IN', and that the traditional >solution was to replace use of 'IN' with 'EXISTS', i.e., > > and EXISTS (select * from userdir where user_name = username and >towncode...) > >Cheers, >Ed Loehr > > > >

Re: [GENERAL] Multi-Language Support and/or UTF-8 UNICODE

2000-02-14 Thread Tatsuo Ishii
> I have been reading in the doc directory of the 6.5.1 tree for information > about UNICODE and UTF-8 support and still have a few questions. > It is not clear to me whether Unicode 2.x and utf-8 or UCS-2 encodings are > available and working okay at this time. Can anyone explain? As stated i

[GENERAL] Multi-Language Support and/or UTF-8 UNICODE

2000-02-14 Thread RK Street
I have been reading in the doc directory of the 6.5.1 tree for information about UNICODE and UTF-8 support and still have a few questions. It is not clear to me whether Unicode 2.x and utf-8 or UCS-2 encodings are available and working okay at this time. Can anyone explain? I get the impress

Re: [GENERAL] converting MSAccess db tables into postgresql

2000-02-14 Thread Yury Don
Hello Marco, Once, Monday, February 14, 2000, 4:11:25 PM, you wrote: MG> I'm really a novice on postgresql but i'm using it on a linux server and MG> i find it really usefull. MG> Now I'd like to convert from MS Access some tables to use them with MG> postgresql. MG> I'm sure must exists a tutor

[GENERAL] Using some indexes but not others

2000-02-14 Thread Peter Haworth
I have a table with a few indexes, which I thought were going to speed up queries using the indexed columns. however, this doesn't appear to be the case. I've got something like this, but with more columns: create table jnl_refs ( ref_article varchar(26) not null, ref_seqno integer not

[GENERAL] converting MSAccess db tables into postgresql

2000-02-14 Thread Marco Giardini
I'm really a novice on postgresql but i'm using it on a linux server and i find it really usefull. Now I'd like to convert from MS Access some tables to use them with postgresql. I'm sure must exists a tutorial on it, or maybe some of you can give me sone hints. Thanks for replying Marco --

No Subject

2000-02-14 Thread Yury Don
Hello All, I am writing the second time about my problem, maybe this time somebody will answer. The problem is following: I use a cyrillic characters in the names of tables and fields. When I use plpgsql function as a trigger I have a record NEW in this function, and consequently this record has