Skip site navigation (1) Skip section navigation (2)

Re: some questions

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
Cc: PostgreSQL Mailing List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: some questions
Date: 2002-07-27 11:09:33
Message-ID: 20020727110933.GA25055@wolff.to (view raw or flat)
Thread:
Lists: pgsql-novice
On Fri, Jul 26, 2002 at 19:26:15 -0700,
  Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com> wrote:
> Hi:
> 
> 1)
>     When I do the ff sql statement
>     select foo
>     from bar
>     limit n;
> 
>     Is it the same as :
>     select foo
>     from bar
>     order by oid
>     limit n;

No. If you don't use order by then there is no guarenteed order.

In response to

pgsql-novice by date

Next:From: tom waDate: 2002-07-27 20:47:32
Subject: functions
Previous:From: Ludwig LimDate: 2002-07-27 02:26:15
Subject: some questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group