[SQL] unique fields

hi: I have a fairly large table. sample_id | chr | cfrom | cto | --- 1c219 20 2c219 20 3c219 20 1c510 11 3c510 11 (25,000 row

Re: [SQL] HowTo divide streetname from house-nr ?

On 23/09/2010 9:25 AM, Andreas wrote: Hi, how could I divide streetnames from housenumbers ? You can't, reliably. There are papers written on the subject of addressing, address analysis, addressing in databases, etc. How would you handle the address: Person's Name RD3 Clemo Rd Whanga

[SQL] HowTo divide streetname from house-nr ?

Hi, how could I divide streetnames from housenumbers ? I have to deal with input like this: Parkstreet 42 Parkstr. 42 Casle Avenue 42 Casle Str. 42-47 Casle Str. 54 - 55 probaply even Casle Str. 42-47 a Perhaps one could cut ap the 1st numeric char and regard everything left of it as the st

Re: [SQL] Question about PQexecParams

Original-Nachricht > Datum: Sun, 12 Sep 2010 01:52:04 +0400 > Von: Dmitriy Igrishin > An: Steve > CC: pgsql-sql@postgresql.org > Betreff: Re: [SQL] Question about PQexecParams > Hey Steve, > > 2010/9/11 Steve > > > Hello list, > > > > I would like to call a function from my

Re: [SQL] insert into help

HI, Please go through http://www.java2s.com/Tutorial/Oracle/0080__Insert-Update-Delete/CopyingRowsfromOneTabletoAnotherINSERTINTOselect.htm Thanks and Regards, Venkat On Wed,

Re: [SQL] insert into help

Le 22/09/2010 09:32, Nicholas I a écrit : > Hi, > > i have two tables, > --- > *table1 > > id type serial, name varchar;* > *-- > table 2 > > name varchar;* >

[SQL] insert into help

Hi, i have two tables, --- *table1 id type serial, name varchar;* *-- table 2 name varchar;* --- i want to insert