X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7FC4A474E5C for ; Sun, 2 Mar 2003 09:10:28 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 28945-01 for ; Sun, 2 Mar 2003 09:10:23 -0500 (EST) Received: from sabre.velocet.net (sabre.velocet.net [216.138.209.205]) by postgresql.org (Postfix) with ESMTP id C9199474E42 for ; Sun, 2 Mar 2003 09:10:23 -0500 (EST) Received: from stark.dyndns.tv (H162.C233.tor.velocet.net [216.138.233.162]) by sabre.velocet.net (Postfix) with ESMTP id A99461380D2; Sun, 2 Mar 2003 09:10:26 -0500 (EST) Received: from localhost ([127.0.0.1] helo=stark.dyndns.tv ident=foobar) by stark.dyndns.tv with smtp (Exim 3.36 #1 (Debian)) id 18pUAb-0000nl-00; Sun, 02 Mar 2003 09:10:25 -0500 To: Jack Kiss Cc: pgsql-sql Subject: Re: Inquiry From Form [pgsql] References: <20030225002258.D78438B68CA@hub.org> In-Reply-To: <20030225002258.D78438B68CA@hub.org> From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 02 Mar 2003 09:10:25 -0500 Message-ID: <87y93xkgfi.fsf@stark.dyndns.tv> Lines: 19 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/48 X-Sequence-Number: 12088 Jack Kiss writes: > 1)Do you have a function which is similar to Oracle\'s DECODE. Yes > 2) Can you extract day of week (Monday,etc) from yours date functions. Yes Check out the "Date/Time Function and Operators" and the "Conditional Expressions" sections of this: http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/functions.html -- greg