Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 9EC419FBE7B
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 16 Mar 2007 10:37:36 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 90923-01-5 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 16 Mar 2007 10:37:26 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from smtpout14.attiva.biz (smtpout14.attiva.biz [85.37.16.16])
	by postgresql.org (Postfix) with ESMTP id 28EAA9FBE87
	for <pgsql-sql@postgresql.org>; Fri, 16 Mar 2007 10:37:25 -0300 (ADT)
Received: from FBCMFE02B12.fbc.local ([192.168.30.89]) by smtpout14.attiva.biz
	with Microsoft SMTPSVC(6.0.3790.1830);
	Fri, 16 Mar 2007 14:37:24 +0100
Received: from dream ([88.34.161.130]) by FBCMFE02B12.fbc.local with Microsoft
	SMTPSVC(6.0.3790.1830); Fri, 16 Mar 2007 14:37:23 +0100
Message-ID: <007901c767d0$3b6ff540$1102a8c0@dream>
Reply-To: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
From: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
To: <pgsql-sql@postgresql.org>
References: <769639.84876.qm@web31809.mail.mud.yahoo.com>
Subject: Re: INSERT INTO
Date: Fri, 16 Mar 2007 14:37:24 +0100
Organization: Studio FORM
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-OriginalArrivalTime: 16 Mar 2007 13:37:23.0753 (UTC)
	FILETIME=[3A9C5190:01C767D0]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.291 tagged_above=0 required=5 tests=AWL, BAYES_50,
	UPPERCASE_25_50
X-Spam-Level: 
X-Archive-Number: 200703/226
X-Sequence-Number: 27864

Thanks alot

^_____________^

Shavonne Wijesinghe
http://www.studioform.it


----- Original Message ----- 
From: "Richard Broersma Jr" <rabroersma@yahoo.com>
To: "Richard Broersma Jr" <rabroersma@yahoo.com>; "Shavonne Marietta 
Wijesinghe" <shavonne.marietta@studioform.it>; <pgsql-sql@postgresql.org>
Sent: Friday, March 16, 2007 2:08 PM
Subject: Re: [SQL] INSERT INTO


>> INSERT INTO TABLE2 (TE_INDI) VALUES ($SANT'ANGELO LODIGIANO$);
>
> My mistake, a single $ will not work you need two like $$:
>
> INSERT INTO TABLE2 (TE_INDI) VALUES ($$SANT'ANGELO LODIGIANO$$);
>
>
> Regards,
> Richard Broersma Jr.