X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4EEFFD1DBA7 for ; Wed, 21 Apr 2004 03:56:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 13318-10 for ; Wed, 21 Apr 2004 03:56:59 -0300 (ADT) Received: from TYO202.gate.nec.co.jp (TYO202.gate.nec.co.jp [210.143.35.52]) by svr1.postgresql.org (Postfix) with ESMTP id 0FF01D1DB8F for ; Wed, 21 Apr 2004 03:56:55 -0300 (ADT) Received: from mailgate3.nec.co.jp (mailgate53.nec.co.jp [10.7.69.160] (may be forged)) by TYO202.gate.nec.co.jp (8.11.7/3.7W01080315) with ESMTP id i3L6unh24521 for ; Wed, 21 Apr 2004 15:56:54 +0900 (JST) Received: (from root@localhost) by mailgate3.nec.co.jp (8.11.7/3.7W-MAILGATE-NEC) id i3L6unl14752 for pgsql-interfaces@postgresql.org; Wed, 21 Apr 2004 15:56:49 +0900 (JST) Received: from fireball.ntsp.nec.co.jp (postfix@[172.28.58.1]) by isgw1.nec.co.jp (8.11.7/3.7W-ISGW-NEC) with ESMTP id i3L6umA27518 for ; Wed, 21 Apr 2004 15:56:48 +0900 (JST) Received: from the-one (localhost [127.0.0.1]) by fireball.ntsp.nec.co.jp (Postfix) with ESMTP id A342B29B0E for ; Wed, 21 Apr 2004 14:56:55 +0800 (HKT) Received: from 172.28.58.4 ([172.28.58.4] helo=galadriel.ntsp.nec.co.jp) by the-one ; 21 Apr 04 06:56:55 -0000 Received: from hq.ntsp.nec.co.jp (frytrix.hq.ntsp.nec.co.jp [172.28.58.129]) by galadriel.ntsp.nec.co.jp (Postfix) with ESMTP id 018CF40202 for ; Wed, 21 Apr 2004 14:56:08 +0800 (PHT) Received: (from smtp@localhost) by hq.ntsp.nec.co.jp (8.9.2/8.9.2) id OAA21861 for ; Wed, 21 Apr 2004 14:56:38 +0800 (HKT) Received: from UNKNOWN(172.28.61.81), claiming to be "hq.ntsp.nec.co.jp" via SMTP by frytrix, id smtpdAAAuGe7c_; Wed Apr 21 06:56:35 2004 Message-ID: <40861D9B.10403@hq.ntsp.nec.co.jp> Date: Wed, 21 Apr 2004 15:07:07 +0800 From: Kenneth Suralta User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: help on SQL Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/48 X-Sequence-Number: 4869 hello everyone, is it possible to get every other row in the table? like for example: data ----- 1 2 3 4 5 6 7 Is it possible to have this result (interval of 3)? result ------ 1 4 7 thanks, kenneth --