It definitely supports date and time datatypes seperately, along with datetime. I will have to check on the sub-selects, views.
-- Robert Garcia BigHead Technology 2781 N Carlmont Pl Simi Valley, CA 93065 Phone 805.501.1390 Fax 805.522.8557 http://www.bighead.net/ [EMAIL PROTECTED] > From: Tom Grimshaw <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Sat, 03 Aug 2002 11:16:40 +1000 > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > Subject: Re: Witango-Talk: Database question > > G'day Robert, > > Does it support the following? > > Sub-Selects > Views > > (which MySQL doesn't) > > and DATE and TIME data types > > (rather than DATETIME). > > Just trying to save myself some homework time here... > > At 15:26 02/08/02 -0400, you wrote: >> Yup >> >> It supports everything you'd need. >> >> Besides the fact that it also has sequences, I love the fact that its >> varchar2 implementation has no size limit. So you can have a >> varchar2(32000) and it works just fine. No need for CLOB >> >> R >> >> On Friday, August 2, 2002, at 02:22 PM, Ben Johansen wrote: >> >>> Hi, >>> Does PostgreSQL support Stored Procedures? >>> >>> Ben Johansen - <http://www.pcforge.com>http://www.pcforge.com >>> Authorized Witango Reseller >>> <http://www.pcforge.com/WitangoGoodies.htm>http://www.pcforge.com/WitangoGoo >>> dies.htm >>> >>> Latest downloads & List Archives @ >>> <http://www.witango.ws>http://www.witango.ws >>> >>> >>> -----Original Message----- >>> From: [EMAIL PROTECTED] >>> [<mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED] >>> m] >>> On Behalf Of Jesse Parker >>> Sent: Friday, August 02, 2002 5:39 AM >>> To: Multiple recipients of list witango-talk >>> Subject: Re: Witango-Talk: Database question >>> >>> I'm very happy with PostgreSQL (www.postgresql.org) >>> >>> I believe MySQL has better and more elaborate administration GUIs than >>> Postgres. >>> >>> I only have experience with Postgres from the command prompt, where it >>> behaves a lot like a well thought out version of Oracle. Backups and >>> restores are very easy. Good SQL client. Support for everything. >>> Commercial support available. >>> >>> >>> On Fri, 2 Aug 2002, Alex Kac wrote: >>> >>>> Here�s a more on-topic question for here.... >>>> >>>> We�re a Win2k shop looking to move to OS X Server 10.2 on XServe. >>> Currently >>>> we�re running SQL Server 2k � but frankly, part of my goal is to get >>> rid of >>>> all MS software for our servers. There are quite a few reasons for >>> this, but >>>> I won�t elaborate. >>>> >>>> Now, my budget is already going to go down the tubes with the >>> XServes...and >>>> possibly WiTango (price still matters, and I�ll say that a large part >>> of my >>>> reluctance to embrace paying $$$ for WiTango 5 is the price and my >>> viewpoint >>>> that yes, its just an SP2 derivative). But you don�t want to skimp on >>> the >>>> database. So...I may just keep one of our servers for SQL Server � but >>> what >>>> low cost or freeware databases do you suggest? MySQL is what many >>> people >>>> seem to use, but from my reading � not experience mind you � its not a >>>> �real� database. Yet large sites like SlashDot and others run off it >>> just >>>> fine. >>>> >>>> I�m not looking for a database war here, I�m not looking for support >>> options >>>> � I�m just asking from what you currently run or have run in the past >>> � what >>>> do you recommend? >>>> >>>> -- >>>> Alex Kac, CEO/Developer >>>> >>>> Innovation in Personal and Business Information Management >>>> <http://www.pocketinformant.com/>http://www.pocketinformant.com/ >>>> >>>> zoomzoom >>>> >>>> >>> >>> ________________________________________________________________________ >>> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >>> with unsubscribe witango-talk in the message body >>> >>> ________________________________________________________________________ >>> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >>> with unsubscribe witango-talk in the message body >> </blockquote></x-html> > > Warmest regards, > > > Tom Grimshaw > coy: Just For You Software > tel: 612 9552 3311 > fax: 612 9566 2164 > mobile: 0414 675 903 > > post: PO Box 470 Glebe NSW 2037 Australia > street: 3/66 Wentworth Park Rd Glebe NSW 2037 > > email: [EMAIL PROTECTED] > web: www.just4usoftware.com.au > > "... the control of impulse -- is the first principle of civilization."-- > Will Durant, > Pulitzer Prize winning philosopher, writer and historian > > the most needed product in the world can be found at > www.thewaytohappiness.org > > This email and any files transmitted with it are confidential to the > intended recipient and may be privileged. If you have received this email > inadvertently or you are not the intended recipient, you may not > disseminate, distribute, copy or in any way rely on it. Further, you should > notify the sender immediately and delete the email from your computer. > Whilst we have taken precautions to alert us to the presence of computer > viruses, we cannot guarantee that this email and any files transmitted with > it are free from such viruses. > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
