Re: [GENERAL] large query by offset and limt

2008-05-03 Thread Ge Cong
Thank you very much. Could you show me how to do it in JDBC? Craig Ringer wrote: > finecur wrote: > > Hi, I am ruuning a database behind a webserver and there is a table > > which is huge. I need to pull data from this table and send to user > > through http. If I use > > > > select * from huge_t

Re: [GENERAL] left outer join on multi tables

2006-10-11 Thread Ge Cong
Thank you, But there seems to be syntax errors. Could you help? Richard Broersma Jr wrote: > > table name > > { > >id integer primary key > >first_name text, > >middle_name text, > >last_name text > > } > > > > table address > > { > >id integer primary key > >number int, >