Received: from Namesrv.Mountain.Net (root@Namesrv.Mountain.Net [198.77.1.1]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA29382 for ; Sat, 9 Oct 1999 16:30:46 -0400 (EDT) (envelope-from dckinder@mountain.net) Received: from duncan (AM6-2.Wheeling-WV.Mountain.Net [198.77.41.102]) by Namesrv.Mountain.Net (8.9.3/8.9.0) with SMTP id QAA03868 for ; Sat, 9 Oct 1999 16:30:40 -0400 (EDT) Message-ID: <04c101bf12ac$b255b720$02010101@duncan> From: "Duncan Kinder" To: Subject: set option question Date: Sat, 9 Oct 1999 16:19:10 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 I am going through The Practical SQL Handbook (Bowman, et al, Addison-Wesley, 1999), which at p. 416 begins to describe the SQL for a sample database used in this book. This sample was designed for Sybase SQLAnywhere, so there appear to be some differences between the book's SQL and Postgres' SQL. In particular: at p. 416, it contains the following SQL: set option date_format='Mmm dd yyyy hh:mmaa' set option date_order = 'MDY' set option scale = 2 when I enter these commands into Postgres, I get the following error: parser: parse error at or near "date_format". Similarly it generates errors for "date_order" and for "scale". What are the equivalent Postgres commands to effect this? Regards, Duncan C. Kinder dckinder@mountain.net