Is following observation regarding "ecpg" correct ?
It is not possible to give different port number from embedded SQLs.
Following gives error on ecpg preprocessor :
exec sql connect to tcp:postgresql://localhost:1234/:dName ;
Where dName is a host variable for database name and 1234 is a port nu
Hi there,
is there any convenient way to find the predecessor of a record given
a particular order of the database?
The following select seems a little bit too expensive.
create table tuples ( i int, j int, m int, k int );
select * from tuples
where ihttp://www.klawitt
I have a DB with is updated using MS Access. Primary keys are Int4 with default random
values ("NuméroAuto" + "Aléatoire" in Access).
The DB is migrated as-is in Postgres, with tbl_prod.cle_prod field containing values
from -2057496808 to 2139583719.
When I SELECT in the table, using the INT4 cl
I have a DB with is updated using MS Access. Primary keys are Int4 with default random
values ("NuméroAuto" + "Aléatoire" in Access).
The DB is migrated as-is in Postgres, with tbl_prod.cle_prod field containing values
from -2057496808 to 2139583719.
When I SELECT in the table, using the INT4 cl
if i have a table:
CREATE TABLE booga
(
name varchar(20),
addr varchar(20)
);
CREATE UNIQUE INDEX booga_idx ON booga (name);
is there a fast way to find the last entry in index booga_idx?
--
[ Jim Mercer [EMAIL PROTECTED] +1 416 506-0654 ]
[ Reptilia
