Marco Gaiarin wrote:
On our organization we are porting an old, internally developed app,
that use Informix (SE 7.XX, on a sun box) as database backend and Gupta
Centura Team Developer 1.5.1 as development environment.
Centura uses Informix via a native driver, for postgres we pass along
odbc. Our
the inquirer wrote:
I am trying to create a function that creates a user
and adds a row to a table. It produces no warnings or
errors when I create the function but when I attempt
to execute it I get a syntax error. I do not
understand why this is happening. Any help would be
greatly appreciate
Christoph Haller wrote:
Michalis Kabrianis wrote:
Hi all,
I have these tables
a (
id integer,
email varchar);
b (
seat varchar,
transactionid varchar);
c (
transactionid varchar,
totalprice numeric(8.2));
---(end of broadcast)---
TIP 8: explain
Hi all,
I have these tables
a (
id integer,
email varchar);
b (
seat varchar,
transactionid varchar);
c (
transactionid varchar,
totalprice numeric(8.2));
---(end of broadcast)---
TIP 8: explain analyze is your friend
Andrei Bintintan wrote:
"Is it safe to use "select max(table1_id) from table1" after the insert?"
Yes it is safe, but ONLY if you use it inside a transaction.(BEGIN/COMMIT).
BR.
Hi,
I think it would be safe to use :
select currval('tablename_idname_seq');
inside a session to receive the current va
sql 7.4 on linux
Is there something I'm doing wrong, something I don't understand or have
I hit a bug?
Thanks in advance
Michalis Kabrianis
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
