Received: from presence1.observatoiredesmarques.fr (presence1.observatoiredesmarques.fr [194.98.239.193]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA57038 for ; Mon, 15 May 2000 13:21:55 -0400 (EDT) (envelope-from richard@presenceweb.com) Received: from presenceweb.com (gatei.observatoiredesmarques.fr [194.98.239.221]) by presence1.observatoiredesmarques.fr (8.9.1/_ODM_070798) with ESMTP id RAA24718 for ; Mon, 15 May 2000 17:26:15 GMT Message-ID: <39202F45.6B31B508@presenceweb.com> Date: Mon, 15 May 2000 19:09:25 +0200 From: Richard NAGY Organization: PresenceWeb X-Mailer: Mozilla 4.72 [fr] (X11; U; Linux 2.2.13-7mdk i586) X-Accept-Language: French, fr, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: translation from ORACLE Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/1 I try to translate a database from Oracle to Postgress. for this reason, i search 3 functions : nvl, max and to_char. ORACLE : ex : EXEC SQL SELECT nvl (attribut, "defaultString") INTO : vattribut FROM ... : if there is no attribut satisfying the select vattribut will be equal to attribut , else vattribut will be equal to attribut. EXEC SQL SELECT max(attribut) .... will give the bigger attribut. EXEC SQL SELECT to_char(attribut, 'DD-MM-YYYY') ... attribut will be a string in the form '01-02-99' I didn't find this 3 functions in Postgress, can you give me them and their syntax. thanks. -- Christine