Re: Inquiry From Form [pgsql]

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