set option question

From: "Duncan Kinder" <dckinder(at)mountain(dot)net>
To: <pgsql-sql(at)postgreSQL(dot)org>
Subject: set option question
Date: 1999-10-09 23:19:10
Message-ID: 04c101bf12ac$b255b720$02010101@duncan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)mountain(dot)net

Browse pgsql-sql by date

  From Date Subject
Next Message Doug Thistlethwaite 1999-10-10 05:04:38 Re: [SQL] combining columns in select
Previous Message nickyk 1999-10-09 17:07:26 Rule question