Re: [SQL] Question on imports with foreign keys

2011-12-09 Thread Emre Hasegeli
On Thu, 08 Dec 2011 12:10:06 +0200, Andreas wrote: Lets's say there were already 1000 records in the customers table. Now I add 357 new customers to this table. If I use one of your queries I'd get all 1357 entries of customers since "project_x.projectinfos" would be newly created for this p

Re: [SQL] Question on imports with foreign keys

2011-12-08 Thread Emre Hasegeli
On Thu, 08 Dec 2011 08:48:51 +0200, Andreas wrote: Hi, suppose you need to import a csv with standard ciolums like name, adress, phone, ... and some additional text columns that need to be split off into referenced tables. Those lookup-tables will only be needed for a project with limite

Re: [SQL] where col1 not ilike ('str1%', 'str2%'... 'strN%') support?

2011-08-31 Thread Emre Hasegeli
2011/8/30 Emi Lu : > First, where not (col1 ~~* any(array['str1%', 'str2%'... 'strN%'])) will > work for me. > > But I feel " ilike ('str1', ... 'strN')" is more intuitive, isn't it? It is not. It is like &q