In fact we are considering various solutions. The ideal one would be to
remain with postgres which reduces the amount of re-implementation of our
current systems, plus remain with a tried and tested system.
Thanks for the tip
Robert
> Please, does anyone know if is there in Postgres's SQL language an
> equivalent for Oracle's TOP ?
Ummm, Oracle's SQL doesn't have a TOP.
Are you thinking of SQL Server?
Cheers,
Colin
---(end of broadcast)---
TIP 1: subscribe and unsubscri
Title: RE: [ADMIN] Re: Top
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Anyway, it's a combination of ORDER BY and LIMIT:
SELECT * FROM table1 ORDER BY field1 DESC LIMIT 10;
or, if you want the bottom ten:
SELECT * FROM table1 ORDER BY field1 LIMIT 10;
Or, if you want the next ten:
Hi Lamer,
I've had a look and the only 7.1.2 rpms is in beta/roswell. I dont' fancy
beta stuff on my production servers. Everything else on the RedHat site is
7.0.x.
You mention RawHide. What is this, and where can I find it.
TIA,
Gary
On Wednesday 08 August 2001 3:47 am, Lamar Owen wrot
On Wed, Aug 08, 2001 at 09:40:21AM +0300, Grigoriy G. Vovk wrote:
> Aug 8, 07:17 +0200, [EMAIL PROTECTED] wrote:
>
> > Does anyone know of any package which allows a database to be distributed
> > over a number of machines (for e.g. depending on row values, rows from 0 -
> > 100 on machine A, row
Hmmm,
I downloaded the postgresql-7.1.2 rpms and tried to install them - I had 20
lines of failed dependancies. I downloaded the RPMS for those, and ended up
with 70+ lines of failed dependancies.
Does anyone have any suggestions on where I should go next (excluding th pub
- I've already ta
On Wed, Aug 08, 2001 at 05:15:13PM +0100, Gary Stainburn wrote:
> Hmmm,
>
> I downloaded the postgresql-7.1.2 rpms and tried to install them - I had 20
> lines of failed dependancies. I downloaded the RPMS for those, and ended up
> with 70+ lines of failed dependancies.
>
> Does anyone have
- Forwarded by Paulo Miranda/RJ/VMCS on 08/08/01 15:39 -
Paulo Miranda
