On Fri, 23 May 2003, Christoph Haller wrote:
> >
> > I am using Java language for getting first 10 records from the table
> in postgres.
> > I dont know how to fetch 10 records from the table.
> > Raj
> >
Could you try
selecy name from bar where serves_greek_tsipouro order by price limit 10;
> First answer is RTFM. But within psql you can fetch like this:
>
> begin;
> declare fu cursor for select * from foo;
> fetch 10 in fu;
> fetch 10 in fu;
> ...
> close fu;
> end;
>
> Does this answer your question?
>
> Regards, Christoph
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr
