From: Duncan Kinder <dckinder@mountain.net>
To: pgsql-sql@postgreSQL.org
Subject: set option question
Date: Sat, 9 Oct 1999 16:19:10 -0700
Message-ID: <04c101bf12ac$b255b720$02010101@duncan> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: dckinder@mountain.net
Subject: Re: set option question
In-Reply-To: <04c101bf12ac$b255b720$02010101@duncan>
References: <04c101bf12ac$b255b720$02010101@duncan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox