Received: from sql.sknet.net (skmail.sknet.sk [195.12.128.7]) by hub.org (8.8.8/8.8.8) with ESMTP id CAA05895 for ; Thu, 17 Sep 1998 02:23:43 -0400 (EDT) (envelope-from apyo@apyo.sk) Received: from WinProxy.anywhere (Dialup32.sknet.sk [195.12.134.34]) by sql.sknet.net with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2232.9) id TAQ4R51C; Thu, 17 Sep 1998 08:19:08 +0100 Received: from 192.168.100.1 by 192.168.100.1 (WinProxy); Wed, 16 Sep 1998 20:42:37 +0100 Message-ID: <3600069D.CC6CEB2D@apyo.sk> Date: Wed, 16 Sep 1998 20:42:37 +0200 From: "Apyo s.r.o." X-Mailer: Mozilla 4.01 [en] (WinNT; I) MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: confused about backslashes X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit In psql: insert into ta (a) values ('\\'); select * from ta; returns a ----------- \\ (1 row) I would expect a ----------- \ (1 row) And also odbc on win is confused about this backslashes. According to previous discussions also jdbc is confused about this. I've followed previous discussion but nobody said that it's a bug of backend. Or or it isn't? So then it's a bug of psql, odbc and jdbc. Could somebody say a conclusion who should fix it? I've seen a patch for odbc but if it's a bug of backend I think it should be fixed in backend. Maybe it's a feature so all others should modify their code to work well with this. But still I think that it wasn't so in previous versions of backend and that's why all interfacing applications expect now \ while backend returns \\. (or it doesn't ?) I'm just a beginning user of postgresql. If you got feeling that I don't understand a word of what I've written above, maybe you're right. I just would like to update my linked tables in M$ACCE$ and is doesn't work. It's not possible to change a varchar field at all. Could somebody help?