Received: from home.macropoint.com (IDENT:root@nisoft-gw.customer.0rbitel.net [195.24.32.214]) by hub.org (8.9.2/8.9.1) with ESMTP id GAA15255 for ; Fri, 5 Feb 1999 06:05:50 -0500 (EST) (envelope-from stancho@macropoint.com) Received: from macropoint.com ([195.24.34.67]) by home.macropoint.com (8.8.7/8.8.7) with ESMTP id NAA07027 for ; Fri, 5 Feb 1999 13:10:18 +0200 Message-ID: <36BAD0BC.200C308C@macropoint.com> Date: Fri, 05 Feb 1999 13:06:36 +0200 From: Stanimir Stanev Organization: MacroTex www.macrotex.com X-Mailer: Mozilla 4.05 [en] (Win95; I) MIME-Version: 1.0 To: "pgsql-sql@hub.org" Subject: date column Content-Type: multipart/mixed; boundary="------------E6AB4B93A228E9126FD5E05D" This is a multi-part message in MIME format. --------------E6AB4B93A228E9126FD5E05D Content-Type: multipart/alternative; boundary="------------18A729617C35B79B900AC843" --------------18A729617C35B79B900AC843 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I have "test" table: +-------+-------+-------+ | Field | Type | length| +-------+-------+-------+ | _date | date | 4 | |-------+-------+-------+ and i want insert into "test" a row: test72=> insert into test ('02/02/1999'); ERROR: parser: parse error at or near "'" how can i insert date into this table? 10x to all Stanimir --------------18A729617C35B79B900AC843 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

I have "test" table:

+-------+-------+-------+
| Field | Type  | length|
+-------+-------+-------+
| _date | date  |   4   |
|-------+-------+-------+

and i want insert into "test" a row:

test72=> insert into test ('02/02/1999');
ERROR:  parser: parse error at or near "'"

how can i insert date into this table?

10x to all
Stanimir --------------18A729617C35B79B900AC843-- --------------E6AB4B93A228E9126FD5E05D Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Stanimir Stanev Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Stanimir Stanev n: Stanev;Stanimir email;internet: stancho@macropoint.com title: software developer x-mozilla-cpt: ;0 x-mozilla-html: TRUE version: 2.1 end: vcard --------------E6AB4B93A228E9126FD5E05D--