Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 8C74DB5DC5E for ; Fri, 4 Nov 2011 11:47:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 32360-04-3 for ; Fri, 4 Nov 2011 14:47:01 +0000 (UTC) X-Greylist: delayed 00:08:24.435846 by SQLgrey-1.8.0-rc2 Received: from newserver.jfcomputer.com (unknown [76.14.161.106]) by mail.postgresql.org (Postfix) with ESMTP id 2AC19B5DC6B for ; Fri, 4 Nov 2011 11:46:57 -0300 (ADT) Received: from localhost (unknown [127.0.0.1]) by newserver.jfcomputer.com (Postfix) with ESMTP id 63EF45E99 for ; Fri, 4 Nov 2011 14:38:30 +0000 (UTC) X-Virus-Scanned: amavisd-new at site Received: from newserver.jfcomputer.com ([127.0.0.1]) by localhost (linux-jfp8.site [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id PP1j2FCHOXYv for ; Fri, 4 Nov 2011 07:38:29 -0700 (PDT) Received: from linux-desktop.localnet (unknown [192.168.1.143]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: johnf@jfcomputer.com) by newserver.jfcomputer.com (Postfix) with ESMTPSA id AC82B2C9C for ; Fri, 4 Nov 2011 07:38:29 -0700 (PDT) From: John Fabiani Organization: J.F. Computer Solutions To: "pgsql-sql@postgresql.org" Subject: the use of $$string$$ Date: Fri, 4 Nov 2011 07:38:29 -0700 User-Agent: KMail/1.13.5 (Linux/2.6.34.10-0.2-desktop; KDE/4.4.4; i686; ; ) MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Message-Id: <201111040738.29303.johnf@jfcomputer.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.107 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RDNS_NONE=0.793 X-Spam-Level: X-Archive-Number: 201111/13 X-Sequence-Number: 35986 Hi, I just discovered that I can use $$string$$ to account for the problem of single quotes in the string (or other strange char's). However, I noticed that the table field contained E'string'. I actually tried to find info on this but I did not find anything. Could someone explain what it means or better provide a web link for me to discover the info. Thanks in advance, Johnf