2009/9/7 Sebastian Krzyszkowiak <[email protected]>: > On 9/7/09, David Reyes Samblas Martinez <[email protected]> wrote: >> [2]select count(*) from package where NOT (package Like '%-doc' or >> package Like '%-dev' or package Like '%-dbg' or package Like 'font-%' >> or package Like 'task-%' or package Like 'ttf-%' or package Like >> '%-locale%' or package Like 'locale-%' or package Like 'lib%' or >> package Like 'kernel-%' or package Like 'perl-%' or package Like >> 'python-%' or package Like 'pulseaudio-%' or package Like >> 'util-linux-%' or package Like 'e-wm-%' or package Like 'alsa-utils-%' >> or package Like 'abiword-%' or package Like 'evas-%' or package Like >> 'etk-%' or package Like 'ecore-%' or package Like 'e2fsprogs-%' or >> package Like 'connman-%' or package Like 'classpath-%' or package Like >> 'edbus-%' or package Like 'edje-%' or package Like 'efrecet-%' or >> package Like 'emotion-%' or package Like 'epsilon-%' or package Like >> 'ewl-%' or package Like 'finch-%' or package Like 'frameworkd-%' or >> package Like 'gdk-%' or package Like 'glibc-%' or package Like >> 'gnome-vfs-%' or package Like 'gpsd-%' or package Like 'gst-%' or >> package Like 'gtk-%' or package Like 'iputils-%' or package Like >> 'midpath-%' or package Like 'openssh-%' or package Like 'pam-%' or >> package Like 'pango-%' or package Like 'pidgin-%' or package Like >> 'ppp-%' or package Like 'pulseaudio-%' or package Like 'tzdata-%' or >> package Like 'xserver-%') Order by package asc > > I think you should leave e-wm-theme-* packages. And you have > pulseaudio-% listed two times :) ok this happens to not do things in order :) fixed in the following query also mateining e-wm-theme packages
select * from package where NOT (package Like '%-doc' or package Like '%-dev' or package Like '%-dbg' or package Like 'font-%' or package Like 'task-%' or package Like 'ttf-%' or package Like '%-locale%' or package Like 'locale-%' or package Like 'lib%' or package Like 'kernel-%' or package Like 'perl-%' or package Like 'python-%' or package Like 'util-linux-%' or package Like 'alsa-utils-%' or package Like 'abiword-%' or package Like 'evas-%' or package Like 'etk-%' or package Like 'ecore-%' or package Like 'e2fsprogs-%' or package Like 'connman-%' or package Like 'classpath-%' or package Like 'edbus-%' or package Like 'edje-%' or package Like 'efrecet-%' or package Like 'emotion-%' or package Like 'epsilon-%' or package Like 'ewl-%' or package Like 'finch-%' or package Like 'frameworkd-%' or package Like 'gdk-%' or package Like 'glibc-%' or package Like 'gnome-vfs-%' or package Like 'gpsd-%' or package Like 'gst-%' or package Like 'gtk-%' or package Like 'iputils-%' or package Like 'midpath-%' or package Like 'openssh-%' or package Like 'pam-%' or package Like 'pango-%' or package Like 'pidgin-%' or package Like 'ppp-%' or package Like 'pulseaudio-%' or package Like 'tzdata-%' or package Like 'xserver-%' or (package Like 'e-wm-%' and not (package Like 'e-wm-theme%'))) > > -- > Sebastian Krzyszkowiak > dos > > _______________________________________________ > Openmoko community mailing list > [email protected] > http://lists.openmoko.org/mailman/listinfo/community > -- David Reyes Samblas Martinez http://www.tuxbrain.com Open ultraportable & embedded solutions Openmoko, Openpandora, Arduino Hey, watch out!!! There's a linux in your pocket!!! _______________________________________________ Openmoko community mailing list [email protected] http://lists.openmoko.org/mailman/listinfo/community
