OS:
Solaris 2.6
uname -a:
SunOS pmlsun.cacs.usl.edu 5.6 Generic_105181-12 sun4u sparc SUNW,Ultra-5_10
postgresql version:
6.4.2
compiler:
cc: WorkShop Compilers 4.2 30 Oct 1996 C 4.2
tools:
GNU Make version 3.76.1, by Richard Stallman and Roland McGrath.
> Subject: Re: [GENERAL] dbase converter
>
> > > Is there a dbase3 <=> postgresql converter available at all? I found
> > > dbf2sql v2.2 which converts to (but not from) Postgres95, with notes such as
> > >
> > > -p primary:
> > > Select the primary key. You have to give the exact
> > >
On Sat, 10 Apr 1999, Mike Frisch wrote:
> With respect to my previous query, I'd like to clarify that the FETCHes I
> am doing are subsets of the full results (hence I cannot use PQntuples).
> For instance, I am FETCHing 25 records out of a possible 1000, so
> PQntuples() is returning 25. I need
On Sat, 10 Apr 1999, Mike Frisch wrote:
> What is the easiest (and least system intensive) method of getting the
> total number of records in the result set? I am presently opening the
> cursor, doing a FETCH ALL, reading PQntuples(), closing the cursor, and
> reopening it for the 'real' work.
>
With respect to my previous query, I'd like to clarify that the FETCHes I
am doing are subsets of the full results (hence I cannot use PQntuples).
For instance, I am FETCHing 25 records out of a possible 1000, so
PQntuples() is returning 25. I need some way of knowing there's a 1000
total.
Thank
What is the easiest (and least system intensive) method of getting the
total number of records in the result set? I am presently opening the
cursor, doing a FETCH ALL, reading PQntuples(), closing the cursor, and
reopening it for the 'real' work.
Background: I am writing a CGI script that pagi
I'm pretty sure someone already answered this, but the mail archive isn't
very searchable at the moment. How can you
if(update row fails because doesn't exist, ie. returns 0)then(insert row)
in SQL? Or am I misremembering and it was in some other language?
Cheers,
Patrick
I have just started to experiment with the new 6.5 beta.
When trying to reload the databases I got an error on what is a pretty
simple SQL command.
The pg_dump was from 6.3.1
I did psql < db.out
The error is
CREATE FUNCTION next_target ( )
RETURNS int4 AS
'update global set next_target=
