Re: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ???

Поиск
Список
Период
Сортировка
От jdassen@cistron.nl (J.H.M. Dassen (Ray))
Тема Re: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ???
Дата
Msg-id slrn9fo1b3.iuj.jdassen@odin.cistron-office.nl
обсуждение исходный текст
Ответ на Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ???  (Robert Beer <Robert.Beer@Callserve.com>)
Список pgsql-sql
Robert Beer <Robert.Beer@Callserve.com> wrote:
> Oracle has a ROWNUM pseudo column that works like this ...
> TEST>select callid, rownum from cs_calls where rownum < 5;

> Is there something like this in PSQL?

SELECT callid FROM cs_calls LIMIT 4;

HTH,
Ray
-- 
Give a man a fire, he's warm for a day.  Set a man on fire, he's warm for
the rest of his life.



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Wei Weng"
Дата:
Сообщение: Is this possible?
Следующее
От: Jeff Eckermann
Дата:
Сообщение: RE: Order by email address by domain ?