Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id D5752475CC7
	for <pgsql-sql@postgresql.org>; Fri, 25 Oct 2002 11:08:29 -0400 (EDT)
Received: from utahisp.com (unknown [66.239.12.3])
	by postgresql.org (Postfix) with ESMTP id 196C6475CBC
	for <pgsql-sql@postgresql.org>; Fri, 25 Oct 2002 11:08:29 -0400 (EDT)
Received: from chad [63.230.8.76] by utahisp.com
	(SMTPD32-5.05) id ADA613802F4; Fri, 25 Oct 2002 09:05:10 -0600
Message-ID: <0e0201c27c38$3a793530$32021aac@chad>
From: "Chad Thompson" <chad@weblinkservices.com>
To: "peter" <peter@peter.com>, "pgsql-sql" <pgsql-sql@postgresql.org>
References: <ap89jn$2e38$1@news.hub.org>
Subject: Re: grouping and first()
Date: Fri, 25 Oct 2002 09:06:17 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Declude-Sender: chad@weblinkservices.com [63.230.8.76]
X-Note: This E-mail was scanned by Declude JunkMail (www.declude.com) for
 spam.
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/360
X-Sequence-Number: 10077

select first(a) from ta order by a

in access, is equivilent to

select a from ta order by a limit 1

Thanks
Chad
P.S.  Note that access will always return the same value if you exclude the
order by, this is not necessarily true with postgresql or any real RDBS.

----- Original Message -----
From: "peter" <peter@peter.com>
To: <pgsql-sql@postgresql.org>
Sent: Thursday, October 24, 2002 2:12 AM
Subject: [SQL] grouping and first()


> Hi, just wondering if anyone can tell me what replaces the first  function
> in access.
>
>
> Thanks
>
> PEter
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>