Re: DUAL Was: Consulting Position Available-Oracle DBA/Developer/

7.0

JP

On Friday 20 September 2002 20:29, you wrote:
> Jan,
>
> Which version of PostgrSQL are you using?
>
> --Walt Weaver
> Bozeman, Montana
>
> -----Original Message-----
> Sent: Friday, September 20, 2002 11:35 AM
> To: Multiple recipients of list ORACLE-L
> DBA/Developer/
>
>
> We are using PostgreSQL, but still have problems with statistics.
> Sometimes after VACUUM ANALYZE optimizer doesn't use indexes
> and performance goes down.
>
> JP
>
> On Friday 20 September 2002 18:43, you wrote:
> > Ditto for PostgreSQL. For portability you can create a dual table but you
> > have to ensure that it only has one row. ;-) I finding that portability
> > between PostgreSQL and Oracle is easier than most... same to_date,
> > to_char functions, and stuff. Seems like that's part of Postgres'
> > strategy.
> >
> >
> > -----Original Message-----
> > Sent: Friday, September 20, 2002 9:24 AM
> > To: Multiple recipients of list ORACLE-L
> > DBA/Developer/NYC
> >
> >
> >
> > As well as in MySQL
> >
> > >There is no need for such table in SQL Server.
> > >If you need, you do just:
> > >
> > >select 'whatever'
> > >
> > >without "from" clause.
> >
> > Gints Plivna
> > IT Sistēmas, Merķeļa 13, LV1050 Rīga
> > http://www.itsystems.lv/gints/

-- 
         Pruner Jan
       jan_at_pruner.cz
     http://jan.pruner.cz/
-----------------------------
Only Robinson Crusoe had all his work done by Friday
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: jan_at_pruner.cz

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).