Re: [GENERAL] Create Table Dinamic

2008-08-06 Thread mian wang
Hi: CREATE OR REPLACE FUNCTION MakeTables ( NameTable text ) RETURNS void as $$ BEGIN execute 'CREATE TABLE '||$1||' ( id int, name text )'; END; $$ LANGUAGE 'plpgsql'; 2008/8/7 Anderson dos Santos Donda <[EMAIL PROTECTED]> > Hello All! > > Its my first time here in maillist and I started wo

Re: [GENERAL] ranked subqueries vs distinct question

2008-05-14 Thread mian wang
2008/5/14 Karsten Hilbert <[EMAIL PROTECTED]>: > Hi all, > > let's assume I want to select cities by name fragment: > >select * from dem.urb where name ilike 'Lei%'; > > Then, let's assume I know the zip code and want to use that > for limiting the range of cities returned: > >sele