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

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: wweaver_at_rightnow.com

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