[SQL] Spam Re: read it immediately

Requested file. Potentially Dangerous Attachment Removed. The file "text.txt.exe" has been blocked. File quarantined as: "". A ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] Wicked screensaver

See the attached file for details ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [SQL] MySql 'REPLACE'

e($data->{$_}), @acols); $self->{_dbh}->do ($sql); } my $sql = "INSERT INTO $table ($names) VALUES ($values)"; $self->{_dbh}->do($sql); $self->{_dbh}->commit; # END TRANSACTION # return $s

[SQL] MySql 'REPLACE'

te it under PostgreSQL? I am using Perl and I can move most of the thing into application anyway. Thanks. -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http://village.albourne.com Nicosia, Cyprus phone: +357-2-755750 "It is m

[SQL] 'Include' function in SQL scripts

I was wondering if PostgreSQL supports some kind of #include between SQL script files, to split a long script in different files. -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http://village.albourne.com Nicosia, Cyprus phone: +357-2-755750

Re: [SQL] "'" in SQL INSERT statement

and escapes all characters that may cause problems in the database backed (e.g. "that's" becomes "that''s" etc.) There is a DBI mailing list where you can find more info and support: see <http://www.isc.org/dbi-lists.html> -- Alessio F. Bragadini

Re: [SQL] Bounds checking on an alias

The named expression isn't available in the WHERE clause. You have to copy the same expression in it. -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http://village.albourne.com Nicosia, Cyprus phone: +357-2-755750 "It is more complicated than you think" -- The Eighth Networking Truth from RFC 1925

Re: [SQL] Confused by timezones

sn't work with any other zone, including GMT (our localtime is EET). I suspect it's a configuration problem on our Digital machine (with Digital Unix 4.0F): zoneinfos are under /etc/zoneinfo. Do the functions use those files or it's just an OS call? Is configure involved at all in this a

Re: [SQL] Confused by timezones

and the best way would be to set a session configuration. My only fear is that Apache::DBI (which reuses the same connection for different pages) could intermix such information. Any comment on this would be appreciated. Thanks -- Alessio F. Bragadini[EMAIL PROTECTED] AP

[SQL] Confused by timezones

or maybe I just don't understand the whole picture... P.S. Ofcourse I can use external functions, e.g. Date::Manip since I code in Perl, but I'd prefer to leave this task to the database itself. -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http: