pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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







Message-ID: <04c101bf12ac$b255b720$02010101@duncan>
Permalink:  ../04c101bf12ac$b255b720$02010101@duncan/
Also on:    postgresql.org/message-id/04c101bf12ac$b255b720$02010101@duncan

 · 

reply

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