[SQL] Help with regexp-query

operand invalid'. I would apreciate some help with this one please. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and Technology

Re: [SQL] pg_dump error

On Mon, Jan 15, 2001 at 08:36:46PM -0500, Tom Lane wrote: Tatsuo Ishii [EMAIL PROTECTED] writes: Can not create pgdump_oid table. Explanation from backend: 'ERROR: cannot create pgdump_oid Is there a way to repair this? I would guess that this means there is a file named

Re: [SQL] pg_dump error - further information

On Mon, Jan 15, 2001 at 08:36:46PM -0500, Tom Lane wrote: I would guess that this means there is a file named "pgdump_oid" hanging around in the database directory, no doubt leftover from some previous pg_dump cycle. Manually removing the file should get you up and running again. However,

Re: [SQL] how many rows? [was Re: fetching rows]

On Fri, Nov 17, 2000 at 10:01:28AM +0100, Arnaud Vandyck wrote: "Robert B. Easter" wrote: you can't do that with a cursor, but you can use they mysql-ism called a limit clause. for example, to fetch rows 26-50 from that query, you'd do: select * from films limit 25,26;