Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id KAA03759 for postgres-dist; Thu, 11 Nov 1993 10:57:39 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199311111857.KAA03759@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from cs.uml.edu (cs.uml.edu [129.63.1.11]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id KAA03750 for <postgres@nobozo.CS.Berkeley.EDU>; Thu, 11 Nov 1993 10:57:36 -0800
Received: by cs.uml.edu id AA14014
  (5.67a+/IDA-1.5 for postgres@postgres.berkeley.edu); Thu, 11 Nov 1993 13:57:34 -0500
From: John Peter Lee <jlee@cs.uml.edu>
Message-Id: <199311111857.AA14014@cs.uml.edu>
Subject: time types
To: postgres@postgres.Berkeley.EDU
Date: Thu, 11 Nov 1993 13:57:34 -0500 (EST)
X-Mailer: ELM [version 2.4 PL22]
Content-Type: text
Content-Length: 957       
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Thu, 11 Nov 93 10:57:39 -0800
Resent-XMts: smtp

Hi:

   I am wondering about how to specify the built-in time types
   in Postgres. Page 23 of my manual gives their syntax, and
   I want to know if when I specify time in libPQ (by building a
   character buffer), do the times have to be double-quoted, like so:

    sprintf (buf, "append db_meta_data ( ... 
	date_created = %s, \			/* <- abstime type */
	...
	range = %s }				/* <- tinterval type */
	)",

	...

	"Nov 12 1993",				/8 date_created */
	
	...

	"[Jan 01 1974, Dec 31 1992]"		/* range */
	);

	query_result = (char *) PQexec ( buf );


	pointers would be appreciated.

	thanks.

	jp

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
JP Lee               Institute for Visualization and Perception Research	
jlee@cs.uml.edu                    University of Massachusetts at Lowell 
(508) 934-3384			      1 University Ave. Lowell, MA 01854

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~