RE: [GENERAL] LIMITS in SELECTs

1999-01-09 Thread Neil Burrows
Hi, > Is there a way to select only a range of rows from a table, using > a command > like: > > SELECT * FROM table WHERE where_statement LIMIT 50,100; Assuming you use a "Order By" clause to make sure you got the records in the appropriate order there is a patch file in the "patches" directory

[GENERAL] Please help with a Solaris 2.6 build error

1999-01-09 Thread Michael Wright
Hi all, I need some help figuring out what this error is and how to correct it. I am using Solaris 2.6 with the Sun cc compiler and gmake. gmake[3]: Entering directory `/export/home/postgres/postgresql-6.4.2/src/interfaces/ecpg/preproc' lex pgc.l "pgc.l":line 53: Error: missing translation value

Re: [GENERAL] LIMITS in SELECTs

1999-01-09 Thread dustin sallings
On Sat, 9 Jan 1999, Fabrice Scemama wrote: // Is there a way to select only a range of rows from a table, using a command // like: // // SELECT * FROM table WHERE where_statement LIMIT 50,100; That doesn't make sense in a relational database by itself since it's not guaranteed to retu

[GENERAL] Databases on Linux

1999-01-09 Thread Richard Vaughan
Hi there, I'm looking into the possibilty of moving some of my development effort onto the Linux platform. I'm employed as a VB/Access programmer and so I want to look at the possibility of (firstly) moving some of the current Access systems over to Linux. Currently one of our main customers is

[GENERAL] Databases on Linux

1999-01-09 Thread Richard Vaughan
Hi there, I'm looking into the possibilty of moving some of my development effort onto the Linux platform. I'm employed as a VB/Access programmer and so I want to look at the possibility of (firstly) moving some of the current Access systems over to Linux. Currently one of our main customers is

[GENERAL] LIMITS in SELECTs

1999-01-09 Thread Fabrice Scemama
Hi ! Is there a way to select only a range of rows from a table, using a command like: SELECT * FROM table WHERE where_statement LIMIT 50,100; I've tried, and then read the doc, but found no information so far. Thanks in advance. Fabrice Scemama

RE: [GENERAL] Benchmarking PGSQL against Microsoft SQL 7

1999-01-09 Thread Bruce Momjian
> There has been a discussion in the HACKERS list (check the archives on > the website > [http:\\www.postgresql.org\]) about PostgreSQL vs MS SQL 6.5 for the > last 2 days or so. > I think these ideas must come in threes, so where is that other person? > > I can't really give a feature comparis