Hey again
I have another question regarding using transactions with perl/dbi.
I think I have the general idea of creating and committing the transactions
etc through the DBI under control but,
My problem is that I'm connecting to the database in one perl script which
opens the transaction, a
I'm having problems opening a transaction through perl DBI
When I try to execute "begin work" using the DBI prepare and execute
functions I get an error:
$sth = $dbh->prepare("begin work");
$sth->execute();
returns this error when I run the perl script from a prompt:
please use DBI functions fo
Hey,
Is there a function within postgres that lets you search for both upper and
lower case at the same time?
I know of the upper() and lower() functions but if a word has both upper and
lower case in it it won't be returned by a query.
Or am I limited to forcing my data to have one case only?
T
Hi,
I'm wondering if it is possible to access the properties of an attribute?
i.e. if a given field is a foreign key or primary key, or if it is integer
or varchar, etc.
Is it possible to do this? I know postgres stores all of its informations in
other tables, i.e. pg_tables etc, so is this info
