Re: [SQL] Caracter é

2005-08-06 Thread Frank Finner
g/reading through Usenet, please send an appropriate >subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail:

Re: [SQL] LIKE '%%' does not return NULL

2004-08-15 Thread Frank Finner
Hi, you should additionally check with IS NULL: SELECT * FROM mytable where myfield like '%%' OR myfield IS NULL if you want to get fields containing NULL as well. A field containing "NULL" in fact contains nothing, not even an empty string, so you cannot catch it with "%". BTW, this holds true

Re: [SQL] working with unix timestamp

2004-03-16 Thread Frank Finner
On Tue, 16 Mar 2004 16:54:18 + Gary Stainburn <[EMAIL PROTECTED]> sat down, thought long and then wrote: > Hi folks. > > I've got a last_updated field on my stock records of type timestamp. > > This last_updated field I get using the perl code: > > my $timestamp=(stat "$localcsv/VehicleStoc

Re: [SQL] flat file database to postgres

2004-03-16 Thread Frank Finner
On Tue, 16 Mar 2004 12:33:57 - (GMT) [EMAIL PROTECTED] sat down, thought long and then wrote: > > Hi > > Does anybody know how to export data from a flatfile (using perl) database > to postgres? > > Thanks If it is some kind of CSV (text with separators) you could use DBD::CSV for reading