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
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 |