The field is, indeed, a char(17) field. This particular database is actually
a copy of the same schema we use in our Informix applications. The
definitions for that system were almost completely correct for creating the
PostgreSQL version, thus many fields are defined as char(x). I shall try
What I'm after are triggers on delete fro several tables calling the same
procedure. I am not at liberty to change the schema of the database as I need
to accomodate what is actually an ancient system - that goes back before the
days of blobs and large text fields. In my example, deleting a r
This function works but is not selective enough. The tg_argv[] are pointers
to the arguments passed. And they do work correctly.
CREATE FUNCTION del_stxnoted () RETURNS opaque AS '
declare
fname text;
rkey text;
BEGIN
fname := tg_argv[0];
rkey := ''old.'' || tg_argv[1];
dele
...the list for inadvertently solving my problem about subscripting. I asked
for a suggestion about rephrasing a query with "...peopcode[1,2] = my_var".
The obvious solution was "...substr(peopcode,1,2)"
Thanks for the unrelated question about updates.
Scott
I'm attempting to compile 7.0.2 on a SCO box. The compile fails attempting to
build ecpg, complaining that nocachegetattr is undefined, first referenced in
pgc.o
I'm unable to find any reference to this. I used the configure options
described in the FAQ_SCO file along with --with-odbc but to
I need to write a C program that will require libpq and ecpg. I'm hoping
someone can point me to an example. I'm not a C programmer, so I need a crash
course or jump start. The original program has existed as an Informix 4GL
program for many years. We have lately been converting our applica
