del = $modelq)
Susan Cassidy
Tom Allison <[EMAIL PROTECTED]>
05/25/2007 04:15 AM
To
[EMAIL PROTECTED]
cc
General PostgreSQL List
Subject
Re: [GENERAL] bytea & perl
I think the quote() part for bytes is deprecated already?
my $string = "(" . join($glue, map{$db
I think the quote() part for bytes is deprecated already?
my $string = "(" . join($glue, map{$dbh->quote($_,PG_BYTEA)} @
$tokens) . ")";
returns
Unknown type 17, defaulting to VARCHAR
as a warning...
On May 24, 2007, at 1:11 PM, [EMAIL PROTECTED] wrote:
Hi,
First, I would advise never
On 5/24/2007, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
>Hi,
>
>First, I would advise never using " insert into xx values (y,x)" without
>explicitly naming the columns; same for select statements - never use
>select * (a table change can mess things up).
>
>By the way, I just noticed in the
ute a statement for the database,
and errexit if it fails either step
my ($statement, $lineno)[EMAIL PROTECTED];
my ($rc);
#get basic machine info
$sth=$dbh->prepare($statement) ||errexit("bad prepare for stmt
$statement at line $lineno, error: $DBI::errstr");
$rc=$s
I've been running into problems with some characters that I believe
can be solved using bytea variable type instead of varchar()
I'm picking up data from email and trying to put it into a table.
I'm trying to "merge" two different types of SQL and I'm really not
sure how this can be done...
