Re: [GENERAL] Counting different strings (OK%, FB%) in same table, grouped by week number

Sent from Samsung mobile Adrian Klaver wrote: >On 02/22/2012 12:36 PM, Alexander Farber wrote: >> Hello, >> >> I have a table holding week numbers (as strings) >> and user ids starting with OK, VK, FB, GG, MR, DE >> (coming through diff. soc. networks to my site): >> >> afarber@www:~> psql >>

Re: [GENERAL] Question on Rules

Thanks I will change to a trigger Best Regards Mike Gould Sent from Samsung mobile David Johnston wrote: >-Original Message- >From: pgsql-general-ow...@postgresql.org >[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of >mgo...@isstrucksoftware.net >Sent: Saturday, February 18,

Re: [GENERAL] version controlling postgresql code

We use svn for all our version control at the moment Sent from Samsung mobile akp geek wrote: >Hi all - > > Would like to know if any one of you have used CVS or some other >version controlling tools to version the postgres code? Any >recommendations? Appreciate your help > >Regards --

Re: [GENERAL] GROUP BY or alternative means to group

You need to include all columns that are not aggregrative columns in the group by. Even though that is the standard it is a pain to list all columns even if you don't need them Best Regards Michael Gould Sent from Samsung mobile Alexander Reichstadt wrote: >Hi, > >the following statement w

Re: [GENERAL] what Linux to run

Thanks to all Sent from Samsung mobile Chris Angelico wrote: >On Wed, Feb 29, 2012 at 3:58 PM, Scott Marlowe wrote: >> Note that Ubuntu also comes in a GUI free server edition as well.  I >> can definitely state that Ubuntu 10.04 LTS Server edition is rock >> solid stable for the hardware I've