X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3BAEB474E4F for ; Tue, 25 Feb 2003 14:31:34 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 66813-08 for ; Tue, 25 Feb 2003 14:31:23 -0500 (EST) Received: from hub.org (hub.org [64.49.215.141]) by postgresql.org (Postfix) with ESMTP id 680E94758DC for ; Tue, 25 Feb 2003 14:31:17 -0500 (EST) Received: from hub.org (hub.org [64.49.215.141]) by hub.org (Postfix) with ESMTP id F003B8CBD53 for ; Tue, 25 Feb 2003 15:31:16 -0400 (AST) X-Received: from localhost ([unix socket]) by hub.org (Cyrus v2.2.prealpha) with LMTP; Mon, 24 Feb 2003 20:23:00 -0400 X-Sieve: CMU Sieve 2.2 X-Received: by hub.org (Postfix, from userid 80) id D78438B68CA; Mon, 24 Feb 2003 20:22:58 -0400 (AST) To: info@pgsql.com Subject: Inquiry From Form [pgsql] From: Jack Kiss Message-Id: <20030225002258.D78438B68CA@hub.org> Date: Mon, 24 Feb 2003 20:22:58 -0400 (AST) X-Spam-Status: No, hits=2.4 required=5.0 tests=DEAR_SOMEBODY,DEAR_SOMETHING,SPAM_PHRASE_01_02 version=2.44 X-Spam-Level: ** ReSent-Date: Tue, 25 Feb 2003 15:31:12 -0400 (AST) Resent-From: "Marc G. Fournier" Resent-To: pgsql-sql@postgresql.org ReSent-Subject: Inquiry From Form [pgsql] ReSent-Message-ID: <20030225153112.R90089@hub.org> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/25 X-Sequence-Number: 12065 Dear Sir/Madam, I would like to find out two things: 1)Do you have a function which is similar to Oracle\'s DECODE. 2) Can you extract day of week (Monday,etc) from yours date functions. Kind Regards, Jack Kiss