X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 86F0947580B for ; Mon, 12 May 2003 13:56:01 -0400 (EDT) Received: from hotmail.com (f69.law12.hotmail.com [64.4.19.69]) by postgresql.org (Postfix) with ESMTP id 71C8C474E42 for ; Mon, 12 May 2003 13:55:57 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 12 May 2003 10:55:57 -0700 Received: from 207.34.65.240 by lw12fd.law12.hotmail.msn.com with HTTP; Mon, 12 May 2003 17:55:57 GMT X-Originating-IP: [207.34.65.240] X-Originating-Email: [daniel_katka@hotmail.com] From: "Katka a Daniel Dunajsky" To: pgsql-sql@postgresql.org Subject: Why this query does not work? Date: Mon, 12 May 2003 11:55:57 -0600 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 12 May 2003 17:55:57.0495 (UTC) FILETIME=[BD8C7C70:01C318AF] X-Spam-Status: No, hits=-1.6 required=5.0 tests=BAYES_30 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/224 X-Sequence-Number: 13389 This works: service0=# SELECT DISTINCT TO_CHAR(session_start, 'Month') as start, service0-# TO_CHAR(session_start, 'Month') as end service0-# FROM user_sessions service0-# WHERE TO_CHAR(session_start, 'YYYY') = '2003'; start | end -----------+----------- April | April (1 row) Why this does not gives correct result? service0=# service0=# SELECT DISTINCT machine_id service0-# FROM user_sessions service0-# WHERE TO_CHAR(session_start, 'Month') = 'April'; machine_id ------------ (0 rows) When this does have no problem? service0=# SELECT DISTINCT machine_id service0-# FROM user_sessions service0-# WHERE TO_CHAR(session_start, 'Month') = (SELECT DISTINCT TO_CHAR(session_start, 'Month') service0(# FROM user_sessions); machine_id ------------ 123 (1 row) Thank you for your time. DanielD _________________________________________________________________ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail