Re: [SQL] assorted Postgres SQL/ORDBMS questions

2003-10-20 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: >> 4. Can dates only be storied in -MM-DD format? > Dates are stored in an internal format in order to ensure compliance with the > SQL date standard. The DATE type is stored as an integer; the TIMESTAMP is > (I believe) binary. Just to clarify: dates

Re: [SQL] assorted Postgres SQL/ORDBMS questions

2003-10-20 Thread Josh Berkus
Clint, > 1. You can raise exceptions but you can't catch exceptions in pgsql right? right. We'd like to do exception-trapping, but nobody has offered to program it. > 2. Does Postgres support ORDBMS operations? > Specifically I am wondering about the ability to define your own objects > and cr

[SQL] assorted Postgres SQL/ORDBMS questions

2003-10-20 Thread Clint Stotesbery
1. You can raise exceptions but you can't catch exceptions in pgsql right? 2. Does Postgres support ORDBMS operations? Specifically I am wondering about the ability to define your own objects and create functions/procedures for the objects (e.g. object.method()). In Oracle I would use CREATE TYPE